Solved

service pack error for sql server 2005

Posted on 2011-03-18
3
458 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

740 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