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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
CRMn00bAuthor Commented:
K my account was alrdy in the local admins group I used the admin account and still got the same failure
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

St3veMaxCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.