SQL Server Upgrade MSP Error: 29538 on KB934458 Upgrade
Greg J.
x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got
the following error as stated in the Summary.txt file.
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934458_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:\SQL\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.
----------------------------------------------------------------------------------
The client tools and workstation components were successfully installed. The
server is still reporting build 3042.
Here is the portions of the HotFix.log file.
05/12/2008 09:19:09.041 Copy Engine: Creating MSP install log file at:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934458_sqlrun_sql.msp.log
05/12/2008 09:19:09.072 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
05/12/2008 09:19:09.103 Registry: Cannot read registry key value "Debug"
05/12/2008 09:21:29.382 MSP Error: 29538 SQL Server Setup did not have the
administrator permissions required to rename a file:
e:\SQL\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.
05/12/2008 09:22:33.678 MSP returned 1603: A fatal error occurred during
installation.
05/12/2008 09:22:33.724 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer"
Any help would be appreciated.
--
Greg
Ekrem Önsoy
I had this kind of problem once and it was because of the Windows
permissions.
In my case, Administrators group acount was removed from the security
permissions list of "C:\Program Files\Microsoft SQL Server" folder.
So, I suggest you to check your Windows account's permissions on setup
folders.
--
Ekrem Önsoy
"Greg J." <Gr...@discussions.microsoft.com> wrote in message
news:34D17D0B-C7DE-4B8C...@microsoft.com...
Gudge
The way I have solved this error is to copy and create the requested file.
I had the exact same error so I looked for the file:
e:\SQL\Data\mssqlsystemresource1.ldf
didn't have one, but I do have this one at;
d:\SQL\Data\mssqlsystemresource.ldf
(we store data on e: and logfiles on d )
Copied this file and pasted it to where the install was looking for it (and
renamed it adding the 1)
Re-ran the install and it ran through successfully.
Then deleted the logfile from the e drive.
Hope this helps.....
Chris from Germany
I am facing the same error message and neither of the 2 options listed above
solve this.
Even worse the SQL Server is now no longer functional, because the
installation aborts I assume in an inconsistent state.
I tried to uninstall the patch via add/remove programs without success.
How can I get my Server back online?
Ekrem Önsoy
Can you try creating an empty\false file that SQL Server asks...
For example Greg said: "e:\SQL\Data\mssqlsystemresource1.ldf" I don't know
yours... But you get it I believe? Create an empty file and name it as SQL
Server Setup asks and try running Setup again and please tell us what
happens.
--
Ekrem Önsoy
"Chris from Germany" <Chrisfro...@discussions.microsoft.com> wrote in
message news:D4E8C4D1-4D1F-4766...@microsoft.com...
Chris from Germany
I've had to copy the files mssqlsystemresource1.mdf, distmdl.ldf and
distmdl.mdf as well.
Now it works.
Regards,
Christian
Ekrem Önsoy
So, Greg also can use this workaround to solve his issue.
Thanks for the feedback.
--
Ekrem Önsoy
"Chris from Germany" <Chrisfro...@discussions.microsoft.com> wrote in
message news:4CA44696-F121-4F5D...@microsoft.com...
mattogatto
Thanks,
MG