Solved

service pack error for sql server 2005

Posted on 2011-03-18
3
451 Views
Last Modified: 2012-06-21
I tried to update the sql server 2005 from service pack 3 to service pack 4 but after updating, I got the followin log msj for only database

Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log
Error Number              : 29538
Error Description         : MSP Error: 29538  SQL Server Setup did not have the administrator permissions required to rename a file: e:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
---------

and I checked that resource databases is available in the location e:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA so what causes this problem?

thanks


msresource.JPG
0
Comment
Question by:teodor76
  • 2
3 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
Comment Utility
Did you run installation as an administrator?
0
 

Author Comment

by:teodor76
Comment Utility
yes,I have admin rights on this server
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
Comment Utility
In this problem there are mainy 3 follwoing reasons:

1. The SQL Server service account doesn’t have sufficient privileges on the DATA folder of SQL Server

2. It is a recommendation that the MSSQLSYSTEMRESOURCE files (MDF and LDF) be in the same location as the master database (KB947989) - it isn't in your case

3. Some services are restarting the SQL service if it is stopped.

SQL Server Setup performs setup in two phases: in the first phase it replaces of binaries and the second phase is running the configuration scripts for updating the metadata.
During the first phase, the SQL Server service is stopped. In case, you have a service which restarts the SQL service at that point, then issue like yours may happen.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now