teodor76
asked on
service pack error for sql server 2005
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_KB2 463332_sql run_sql.ms p.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\ mssqlsyste mresource1 .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
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_
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\
---------
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
Did you run installation as an administrator?
ASKER
yes,I have admin rights on this server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.