RE: SQL Server Upgrade MSP Error: 29538 on KB934458 Upgrade

Greg.
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.....



"Greg J." wrote:

We have a server instance on SQL Server 2005 SP2 build 3042. We have a 32 bit
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
.

Relevant Pages

  • SQL Server Upgrade MSP Error: 29538 on KB934458 Upgrade
    ... Product Installation Status ... and either grant administrator permissions to the account currently ... running Setup or log in with an administrator account. ...
    (microsoft.public.sqlserver.setup)
  • Re: Vista development, the dos and dont???
    ... the C# program first starts. ... Visual Studio 2005 always needs the user to run it as an Administrator ... During the install of VS2008, it asks the user to run ... with Administrator permissions. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Lost My Search Ability START>SEARCH Re: Don
    ... administrator permissions. ... Install. ... This reinstalls the files that Search Companion uses. ...
    (microsoft.public.windowsxp.general)
  • Re: XP, Logitech mice & limited users
    ... Hmmm...I am a Limited User at work, and one of our desktop guys (who has Administrator permissions) recently installed Setpoint 2.6 on my computer. ... I suggest you reinstall the software, being sure to install it in the user's account. ... Failing that I would contact Logitech technical support. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Lost XP product key - before install.
    ... if the app is installed by an administrator it will automagically be ... significant number of applications do install for the user *and* require ... administrator permissions to install correctly. ...
    (uk.comp.homebuilt)