0x2B22

Update will not install because Sqlserver will not start

Have tried to start manually and it will not start??


Update: Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)


Summary.txt

Time: 04/17/2007 13:40:07.015
KB Number: KB921896
Machine: ST
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 (SQLEXPRESS) ENU RTM 2005.090.1399.00
x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM
x86 EXPRESS

************************************************** ********************************
Products Disqualified & Reason
Product Reason
Express Database Services (SQLEXPRESS) Unable to start service

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

************************************************** ********************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features :
SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_Shar edTools
Error Number : 11042
Error Description : Unable to start service
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

************************************************** ********************************
Summary
Unable to start service
Exit Code Returned: 11042

When you start manaully do you get an error? If so, what is the error?
--
Thanks,
Peter Saddow -- Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.



"HM" <> wrote in message
news:B0D5F7A7-9BF1-470A-8B68-...
> Update will not install because Sqlserver will not start
>
> Have tried to start manually and it will not start??
>
>
> Update: Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB
> 921896)
>
>
> Summary.txt
>
> Time: 04/17/2007 13:40:07.015
> KB Number: KB921896
> Machine: ST
> 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 (SQLEXPRESS) ENU RTM
> 2005.090.1399.00
> x86 EXPRESS
> Express Database Services (SQLExpress) ENU RTM
> x86 EXPRESS
>
> ************************************************** ********************************
> Products Disqualified & Reason
> Product Reason
> Express Database Services (SQLEXPRESS) Unable to start service
>
> ************************************************** ********************************
> Processes Locking Files
> Process Name Feature Type User Name
> PID
>
> ************************************************** ********************************
> Product Installation Status
> Product : Express Database Services (SQLEXPRESS)
> Product Version (Previous): 1399
> Product Version (Final) :
> Status : Not Applied
> Log File :
> SQL Express Features :
> SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_Shar edTools
> Error Number : 11042
> Error Description : Unable to start service
> ----------------------------------------------------------------------------------
> Product : Express Database Services (SQLExpress)
> Product Version (Previous):
> Product Version (Final) :
> Status : Not Applied
> Log File :
> SQL Express Features : Client_Components,Connectivity,SDK
> Error Number : 0
> Error Description :
> ----------------------------------------------------------------------------------
>
> ************************************************** ********************************
> Summary
> Unable to start service
> Exit Code Returned: 11042
>
>
>

I use a non-English version so I'll try to translate

1) Start->Controlpanel->Administration->Services

2) Right-click on SQL Server (SQLEXPRESS) and chose start.

3) Pop-up window:

Windows could not start SQL Server (SQLEXPRESS) on Local computer. Further
information can be found in the system log. Contact you service provider if
this is a non-Microsoft service and refer to the service specific error code.
3417.

If I change the "Log on as:" from

Built-in account: Network Service

to

Built-in account: Local System


Then the service starts without any problem. But I don't know if this is a
good enough solution??

Peter:

You seem to have some experience with this. I have looked around on the
internet to try and find an answer for the same problem. I have checked to
make sure the master files are not compressed. I have tried to restart the
service through the services page. I have also changed the user from Network
Services to Local System Account. So far none has worked. Besides having
SQLExpress Installed, I also have SQL Developers Edition 2005 and SQL 2000
installed. I have also tried to update SQL Developers Edition 2005 update
(Update for SQL Server 2005 (KB 932557)) and I am getting the same error.
Below are both my summary log. If you like, I can also post the hot fix log.
Any help that you can give would be greatly appreciated.

Sincerely,

Robs

Time: 05/19/2007 10:14:53.406
KB Number: KB932557
Machine: ROBSHOMEMACHINE
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 0
Package Version: 1406
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

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

************************************************** ********************************
Products Detected Language Level Patch Level
Platform Edition
SQL Server Database Services 2005 (SQL2005) ENU RTM
2005.090.1399.00 x86 DEVELOPER
SQL Server Analysis Services 2005 (SQL2005) ENU RTM
2005.090.1399.00 x86 DEVELOPER
SQL Server Reporting Services 2005 (SQL2005) ENU RTM
9.00.1399.00 x86 DEVELOPER
SQL Server Database Services 2005 (SQLEXPRESS) ENU RTM
2005.090.1399.00 x86 EXPRESS
SQL Server Notification Services 2005 ENU RTM 9.00.1399.00
x86 DEVELOPER
SQL Server Integration Services 2005 ENU RTM 9.00.1399.00
x86 DEVELOPER
SQL Server Tools and Workstation Components 2005 ENU RTM
9.00.1399.06 x86 DEVELOPER

************************************************** ********************************
Products Disqualified & Reason
Product Reason
SQL Server Database Services 2005 (SQLEXPRESS) Unable to start service

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

************************************************** ********************************
Product Installation Status
Product : SQL Server Database Services 2005 (SQL2005)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Analysis Services 2005 (SQL2005)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Reporting Services 2005 (SQL2005)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Database Services 2005 (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features :
Error Number : 11042
Error Description : Unable to start service
----------------------------------------------------------------------------------
Product : SQL Server Notification Services 2005
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Integration Services 2005
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

************************************************** ********************************
Summary
Unable to start service
Exit Code Returned: 11042