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

Hello Greg,

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." <GregJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:34D17D0B-C7DE-4B8C-9919-070C7E37281E@xxxxxxxxxxxxxxxx
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

  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)
  • Re: EMERGENCY: Files lost
    ... Windows XP Home Edition, with SP2. ... or other folders and files at that level. ... Administrator, I do have normal access to all files and folders. ... You now need to edit the permissions of every file (step 6 on my page. ...
    (microsoft.public.windowsxp.configuration_manage)
  • Re: User Account Suddenly Unaccessable
    ... Revert to the original profile folder. ... Log on as administrator ... The Sharing tab has "Do not share this folder" checked, and the rest of the tab has no data. ... In the middle section none of the "permissions" categories have any checkmarks - no marks in allow, ...
    (microsoft.public.win2000.general)
  • Re: Do not have accessibility to change certain file names
    ... ownership and permissions supersede administrator rights. ... you can set XP Home permissions in Safe Mode. ... Open Explorer, go to Tools and Folder Options, on the view tab, scroll to ...
    (microsoft.public.windowsxp.accessibility)