Solved

service pack error for sql server 2005

Posted on 2011-03-18
3
453 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
ID: 35164168
Did you run installation as an administrator?
0
 

Author Comment

by:teodor76
ID: 35164292
yes,I have admin rights on this server
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35164523
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql sERVER PARSE DATA BY HOURS AND COLUMNS 2 42
Need help creating a stored procedure 4 57
sql Audit table 3 59
SQL Query with Sum and Detail rows 2 42
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 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

17 Experts available now in Live!

Get 1:1 Help Now