Database Services Failing the upgrade to SP2

I am trying to set up SQL server 2005 on my New database server I did the install and everything went fine till I tried to upgrade to SP2 all of them passed except database services i searched for the answer but none specific to my problem because I am not running a cluster environment any help would be great, thanks.
Time: 11/17/2008 14:53:09.281
KB Number: KB921896
Machine: INSOLEXDB1
OS Version: Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
 
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
 
**********************************************************************************
Products Detected                         Language  Level  Patch Level       Platform  Edition
Setup Support Files                       ENU                     9.2.3042  x64       
Database Services (MSSQLSERVER)           ENU       RTM    2005.090.1399.00  x64       STANDARD
Analysis Services (MSSQLSERVER)           ENU       SP2    2005.090.3042.00  x64       STANDARD
Reporting Services (MSSQLSERVER)          ENU       SP2       9.00.3042.00  x64       STANDARD
Notification Services                     ENU       SP2       9.00.3042.00  x64       STANDARD
Integration Services                      ENU       SP2       9.00.3042.00  x64       STANDARD
SQL Server Native Client                  ENU                 9.00.3042.00  x64       
Client Components                         ENU       SP2           9.2.3042  x64       STANDARD
MSXML 6.0 Parser                          ENU                  6.20.1099.0  x64       
SQLXML4                                   ENU                 9.00.3042.00  x64       
Backward Compatibility                    ENU                    8.05.2004  x64       
 
**********************************************************************************
Products Disqualified & Reason
Product                                   Reason
 
**********************************************************************************
Processes Locking Files
Process Name          Feature               Type          User Name                  PID
msftesql              Database Services     Service       NT AUTHORITY\SYSTEM        6488
MSSQLSERVER           Database Services     Service       NT AUTHORITY\SYSTEM        1896
SQLSERVERAGENT        Database Services     Service       NT AUTHORITY\SYSTEM        5308
 
**********************************************************************************
Product Installation Status
Product                   : Setup Support Files
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final)   : 
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number              : 1920
Error Description         : MSP Error: 1920  Service 'SQLWriter' (SQLWriter) failed to start.  Verify that you have sufficient privileges to start system services.
----------------------------------------------------------------------------------
Product                   : Analysis Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Number              : 0
Error Description         :
----------------------------------------------------------------------------------
Product                   : Reporting Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Number              : 0
Error Description         :
----------------------------------------------------------------------------------
Product                   : Notification Services
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Integration Services
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Client Components
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : MSXML 6.0 Parser
Product Version (Previous): 1099
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQLXML4
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
 
**********************************************************************************
Summary
     One or more products failed to install, see above for details
     Exit Code Returned: 1920

Open in new window

CRMn00bAsked:
Who is Participating?
 
St3veMaxConnect With a Mentor Commented:
Hmm, I can only suggest trying to reinstall SQLWriter; Browse your SQL 2005 installation CD, and in the setup folder you should see a file called SQLWriter.msi

Install that; Reboot and see if that's repaired the issue.

HTH
0
 
St3veMaxCommented:
OK,
The obvious one is; is the service started?

You could try putting either your account or the SQL Service account in Local Admins whilst you apply SP2 and then remove once done.

Give this a whirl and report back.

HTH
0
 
CRMn00bAuthor Commented:
at the time of upgrade yes the service was started I will try your solution and let you know
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
CRMn00bAuthor Commented:
K my account was alrdy in the local admins group I used the admin account and still got the same failure
0
 
CRMn00bAuthor Commented:
that worked thanks
0
 
adauserCommented:
I had the same problem, the log file from the failed SP2 installation suggested to start the Remote Registry services and then go to add/remove programs>select SQL 2005> CHANGE and go through the installation process. Then you can apply SP2 successfully. READ the log first and see if you can find the same suggestion. Hope this helps!

Thanks
RM
0
 
tk1solutionsCommented:
St3v3Max's solution of reinstalling SQLwriter was right on the money.  once i did that from the orignal install software, the update went through with no problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.