Installation failed: SQL Server Service Pack 2 - Please help.

When trying to install the new SQL Server Service Pack 2, the installation
fails. I get Error Code: 0x2B26. The desktop application that uses SQL
Server is ACT 2007.

SQL Server's normal status when booting the system and before starting ACT is
"running" and "automatic". I've tried stopping the SQL Server Process and
cheanged its type from "automatic" to "manual".

BTW: I've been wanting to buy a new laptop with Vista but the ACT
application needs elements of SQL Server that Vista reportedly doesn't
support. Does Service Pack 2 address this deficiency?

Thanks for the help! Below you will find the file called "summary.txt" that
logged the failed installation attempt:

Time: 03/07/2007 22:59:51.390
KB Number: KB921896
Machine: PARENTSWORLD
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

************************************************** ********************************
Prerequisites Check & Status
SQLSupport: Passed

************************************************** ********************************
Products Detected Language Level Patch Level
Platform Edition
Express Database Services (ACT7) ENU SP1 2005.090.2170.00
x86 EXPRESS
Express Database Services (SQLExpress) ENU SP1
x86 EXPRESS

************************************************** ********************************
Products Disqualified & Reason
Product Reason
Express Database Services (ACT7) User authentication failed.
Please check to see if the password provided is correct or check to see if
the SQL Server Instance is set to Mixed Authentication

************************************************** ********************************
Processes Locking Files
Process Name Feature Type User Name
PID

************************************************** ********************************
Product Installation Status
Product : Express Database Services (ACT7)
Product Version (Previous): 2170
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 11046
Error Description : User authentication failed. Please check to see
if the password provided is correct or check to see if the SQL Server
Instance is set to Mixed Authentication
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : Client_Components,Connectivity
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

************************************************** ********************************
Summary
User authentication failed. Please check to see if the password
provided is correct or check to see if the SQL Server Instance is set to
Mixed Authentication
Exit Code Returned: 11046

I am having the same problem. Running Act 2007 for Workgroups. Also today
before trying to run the update Act Syn Server would not start. This is
totally new and never happened before.

Alan

"Techjunkie" wrote:

> When trying to install the new SQL Server Service Pack 2, the installation
> fails. I get Error Code: 0x2B26. The desktop application that uses SQL
> Server is ACT 2007.
>
> SQL Server's normal status when booting the system and before starting ACT is
> "running" and "automatic". I've tried stopping the SQL Server Process and
> cheanged its type from "automatic" to "manual".
>
> BTW: I've been wanting to buy a new laptop with Vista but the ACT
> application needs elements of SQL Server that Vista reportedly doesn't
> support. Does Service Pack 2 address this deficiency?
>
> Thanks for the help! Below you will find the file called "summary.txt" that
> logged the failed installation attempt:
>
> Time: 03/07/2007 22:59:51.390
> KB Number: KB921896
> Machine: PARENTSWORLD
> OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
> Package Language: 1033 (ENU)
> Package Platform: x86
> Package SP Level: 2
> Package Version: 3042
> Command-line parameters specified:
> /quiet
> /allinstances
> Cluster Installation: No
>
> ************************************************** ********************************
> Prerequisites Check & Status
> SQLSupport: Passed
>
> ************************************************** ********************************
> Products Detected Language Level Patch Level
> Platform Edition
> Express Database Services (ACT7) ENU SP1 2005.090.2170.00
> x86 EXPRESS
> Express Database Services (SQLExpress) ENU SP1
> x86 EXPRESS
>
> ************************************************** ********************************
> Products Disqualified & Reason
> Product Reason
> Express Database Services (ACT7) User authentication failed.
> Please check to see if the password provided is correct or check to see if
> the SQL Server Instance is set to Mixed Authentication
>
> ************************************************** ********************************
> Processes Locking Files
> Process Name Feature Type User Name
> PID
>
> ************************************************** ********************************
> Product Installation Status
> Product : Express Database Services (ACT7)
> Product Version (Previous): 2170
> Product Version (Final) :
> Status : Not Applied
> Log File :
> SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> Error Number : 11046
> Error Description : User authentication failed. Please check to see
> if the password provided is correct or check to see if the SQL Server
> Instance is set to Mixed Authentication
> ----------------------------------------------------------------------------------
> Product : Express Database Services (SQLExpress)
> Product Version (Previous):
> Product Version (Final) :
> Status : Not Applied
> Log File :
> SQL Express Features : Client_Components,Connectivity
> Error Number : 0
> Error Description :
> ----------------------------------------------------------------------------------
>
> ************************************************** ********************************
> Summary
> User authentication failed. Please check to see if the password
> provided is correct or check to see if the SQL Server Instance is set to
> Mixed Authentication
> Exit Code Returned: 11046
>
>
>
>

I have three PC's in my house, running XP. I did the updates to Service Pack
2 today. It worked on all of them but the one with an ACT! database running
on it. In that case the update wouldn't install.

"Alan" wrote:

> I am having the same problem. Running Act 2007 for Workgroups. Also today
> before trying to run the update Act Syn Server would not start. This is
> totally new and never happened before.
>
> Alan
>
> "Techjunkie" wrote:
>
> > When trying to install the new SQL Server Service Pack 2, the installation
> > fails. I get Error Code: 0x2B26. The desktop application that uses SQL
> > Server is ACT 2007.
> >
> > SQL Server's normal status when booting the system and before starting ACT is
> > "running" and "automatic". I've tried stopping the SQL Server Process and
> > cheanged its type from "automatic" to "manual".
> >
> > BTW: I've been wanting to buy a new laptop with Vista but the ACT
> > application needs elements of SQL Server that Vista reportedly doesn't
> > support. Does Service Pack 2 address this deficiency?
> >
> > Thanks for the help! Below you will find the file called "summary.txt" that
> > logged the failed installation attempt:
> >
> > Time: 03/07/2007 22:59:51.390
> > KB Number: KB921896
> > Machine: PARENTSWORLD
> > OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
> > Package Language: 1033 (ENU)
> > Package Platform: x86
> > Package SP Level: 2
> > Package Version: 3042
> > Command-line parameters specified:
> > /quiet
> > /allinstances
> > Cluster Installation: No
> >
> > ************************************************** ********************************
> > Prerequisites Check & Status
> > SQLSupport: Passed
> >
> > ************************************************** ********************************
> > Products Detected Language Level Patch Level
> > Platform Edition
> > Express Database Services (ACT7) ENU SP1 2005.090.2170.00
> > x86 EXPRESS
> > Express Database Services (SQLExpress) ENU SP1
> > x86 EXPRESS
> >
> > ************************************************** ********************************
> > Products Disqualified & Reason
> > Product Reason
> > Express Database Services (ACT7) User authentication failed.
> > Please check to see if the password provided is correct or check to see if
> > the SQL Server Instance is set to Mixed Authentication
> >
> > ************************************************** ********************************
> > Processes Locking Files
> > Process Name Feature Type User Name
> > PID
> >
> > ************************************************** ********************************
> > Product Installation Status
> > Product : Express Database Services (ACT7)
> > Product Version (Previous): 2170
> > Product Version (Final) :
> > Status : Not Applied
> > Log File :
> > SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> > Error Number : 11046
> > Error Description : User authentication failed. Please check to see
> > if the password provided is correct or check to see if the SQL Server
> > Instance is set to Mixed Authentication
> > ----------------------------------------------------------------------------------
> > Product : Express Database Services (SQLExpress)
> > Product Version (Previous):
> > Product Version (Final) :
> > Status : Not Applied
> > Log File :
> > SQL Express Features : Client_Components,Connectivity
> > Error Number : 0
> > Error Description :
> > ----------------------------------------------------------------------------------
> >
> > ************************************************** ********************************
> > Summary
> > User authentication failed. Please check to see if the password
> > provided is correct or check to see if the SQL Server Instance is set to
> > Mixed Authentication
> > Exit Code Returned: 11046
> >
> >
> >
> >

This is happening because the ACT application is removing all of the Windows
Groups that are needed by the update program to be able to upgrade the
database to SP2. We are working with the ACT team to provide a working as
Microsoft does not have a solution. Feel free to contact ACT also to inform
them about this issue.

Thanks,
Peter Saddow

"Steve" wrote:

> I have three PC's in my house, running XP. I did the updates to Service Pack
> 2 today. It worked on all of them but the one with an ACT! database running
> on it. In that case the update wouldn't install.
>
> "Alan" wrote:
>
> > I am having the same problem. Running Act 2007 for Workgroups. Also today
> > before trying to run the update Act Syn Server would not start. This is
> > totally new and never happened before.
> >
> > Alan
> >
> > "Techjunkie" wrote:
> >
> > > When trying to install the new SQL Server Service Pack 2, the installation
> > > fails. I get Error Code: 0x2B26. The desktop application that uses SQL
> > > Server is ACT 2007.
> > >
> > > SQL Server's normal status when booting the system and before starting ACT is
> > > "running" and "automatic". I've tried stopping the SQL Server Process and
> > > cheanged its type from "automatic" to "manual".
> > >
> > > BTW: I've been wanting to buy a new laptop with Vista but the ACT
> > > application needs elements of SQL Server that Vista reportedly doesn't
> > > support. Does Service Pack 2 address this deficiency?
> > >
> > > Thanks for the help! Below you will find the file called "summary.txt" that
> > > logged the failed installation attempt:
> > >
> > > Time: 03/07/2007 22:59:51.390
> > > KB Number: KB921896
> > > Machine: PARENTSWORLD
> > > OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
> > > Package Language: 1033 (ENU)
> > > Package Platform: x86
> > > Package SP Level: 2
> > > Package Version: 3042
> > > Command-line parameters specified:
> > > /quiet
> > > /allinstances
> > > Cluster Installation: No
> > >
> > > ************************************************** ********************************
> > > Prerequisites Check & Status
> > > SQLSupport: Passed
> > >
> > > ************************************************** ********************************
> > > Products Detected Language Level Patch Level
> > > Platform Edition
> > > Express Database Services (ACT7) ENU SP1 2005.090.2170.00
> > > x86 EXPRESS
> > > Express Database Services (SQLExpress) ENU SP1
> > > x86 EXPRESS
> > >
> > > ************************************************** ********************************
> > > Products Disqualified & Reason
> > > Product Reason
> > > Express Database Services (ACT7) User authentication failed.
> > > Please check to see if the password provided is correct or check to see if
> > > the SQL Server Instance is set to Mixed Authentication
> > >
> > > ************************************************** ********************************
> > > Processes Locking Files
> > > Process Name Feature Type User Name
> > > PID
> > >
> > > ************************************************** ********************************
> > > Product Installation Status
> > > Product : Express Database Services (ACT7)
> > > Product Version (Previous): 2170
> > > Product Version (Final) :
> > > Status : Not Applied
> > > Log File :
> > > SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> > > Error Number : 11046
> > > Error Description : User authentication failed. Please check to see
> > > if the password provided is correct or check to see if the SQL Server
> > > Instance is set to Mixed Authentication
> > > ----------------------------------------------------------------------------------
> > > Product : Express Database Services (SQLExpress)
> > > Product Version (Previous):
> > > Product Version (Final) :
> > > Status : Not Applied
> > > Log File :
> > > SQL Express Features : Client_Components,Connectivity
> > > Error Number : 0
> > > Error Description :
> > > ----------------------------------------------------------------------------------
> > >
> > > ************************************************** ********************************
> > > Summary
> > > User authentication failed. Please check to see if the password
> > > provided is correct or check to see if the SQL Server Instance is set to
> > > Mixed Authentication
> > > Exit Code Returned: 11046
> > >
> > >
> > >
> > >

Peter... has there been any resolution to this issue? I have turned off the
update for KB921896 until there is some sort of work around... Thank you for
your help/advice on this.

"Peter Saddow [Microsoft]" wrote:

> This is happening because the ACT application is removing all of the Windows
> Groups that are needed by the update program to be able to upgrade the
> database to SP2. We are working with the ACT team to provide a working as
> Microsoft does not have a solution. Feel free to contact ACT also to inform
> them about this issue.
>
> Thanks,
> Peter Saddow
>
> "Steve" wrote:
>
> > I have three PC's in my house, running XP. I did the updates to Service Pack
> > 2 today. It worked on all of them but the one with an ACT! database running
> > on it. In that case the update wouldn't install.
> >
> > "Alan" wrote:
> >
> > > I am having the same problem. Running Act 2007 for Workgroups. Also today
> > > before trying to run the update Act Syn Server would not start. This is
> > > totally new and never happened before.
> > >
> > > Alan
> > >
> > > "Techjunkie" wrote:
> > >
> > > > When trying to install the new SQL Server Service Pack 2, the installation
> > > > fails. I get Error Code: 0x2B26. The desktop application that uses SQL
> > > > Server is ACT 2007.
> > > >
> > > > SQL Server's normal status when booting the system and before starting ACT is
> > > > "running" and "automatic". I've tried stopping the SQL Server Process and
> > > > cheanged its type from "automatic" to "manual".
> > > >
> > > > BTW: I've been wanting to buy a new laptop with Vista but the ACT
> > > > application needs elements of SQL Server that Vista reportedly doesn't
> > > > support. Does Service Pack 2 address this deficiency?
> > > >
> > > > Thanks for the help! Below you will find the file called "summary.txt" that
> > > > logged the failed installation attempt:
> > > >
> > > > Time: 03/07/2007 22:59:51.390
> > > > KB Number: KB921896
> > > > Machine: PARENTSWORLD
> > > > OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
> > > > Package Language: 1033 (ENU)
> > > > Package Platform: x86
> > > > Package SP Level: 2
> > > > Package Version: 3042
> > > > Command-line parameters specified:
> > > > /quiet
> > > > /allinstances
> > > > Cluster Installation: No
> > > >
> > > > ************************************************** ********************************
> > > > Prerequisites Check & Status
> > > > SQLSupport: Passed
> > > >
> > > > ************************************************** ********************************
> > > > Products Detected Language Level Patch Level
> > > > Platform Edition
> > > > Express Database Services (ACT7) ENU SP1 2005.090.2170.00
> > > > x86 EXPRESS
> > > > Express Database Services (SQLExpress) ENU SP1
> > > > x86 EXPRESS
> > > >
> > > > ************************************************** ********************************
> > > > Products Disqualified & Reason
> > > > Product Reason
> > > > Express Database Services (ACT7) User authentication failed.
> > > > Please check to see if the password provided is correct or check to see if
> > > > the SQL Server Instance is set to Mixed Authentication
> > > >
> > > > ************************************************** ********************************
> > > > Processes Locking Files
> > > > Process Name Feature Type User Name
> > > > PID
> > > >
> > > > ************************************************** ********************************
> > > > Product Installation Status
> > > > Product : Express Database Services (ACT7)
> > > > Product Version (Previous): 2170
> > > > Product Version (Final) :
> > > > Status : Not Applied
> > > > Log File :
> > > > SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
> > > > Error Number : 11046
> > > > Error Description : User authentication failed. Please check to see
> > > > if the password provided is correct or check to see if the SQL Server
> > > > Instance is set to Mixed Authentication
> > > > ----------------------------------------------------------------------------------
> > > > Product : Express Database Services (SQLExpress)
> > > > Product Version (Previous):
> > > > Product Version (Final) :
> > > > Status : Not Applied
> > > > Log File :
> > > > SQL Express Features : Client_Components,Connectivity
> > > > Error Number : 0
> > > > Error Description :
> > > > ----------------------------------------------------------------------------------
> > > >
> > > > ************************************************** ********************************
> > > > Summary
> > > > User authentication failed. Please check to see if the password
> > > > provided is correct or check to see if the SQL Server Instance is set to
> > > > Mixed Authentication
> > > > Exit Code Returned: 11046
> > > >
> > > >
> > > >
> > > >