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_s ql.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_s ql.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 would be appreciated.

--
Greg

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@discussions.microsoft.com> wrote in message
news:34D17D0B-C7DE-4B8C-9919-070C7E37281E@microsoft.com...
> 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_s ql.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_s ql.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 would be appreciated.
>
> --
> Greg

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



"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_s ql.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_s ql.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 would be appreciated.
>
> --
> Greg

Hi,

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?


"Gudge" wrote:

> 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 s.....
>
>
>
> "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_s ql.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_s ql.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 would be appreciated.
> >
> > --
> > Greg

Chris,

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" <ChrisfromGermany@discussions.microsoft.com> wrote in
message news4E8C4D1-4D1F-4766-9636-2E35A1E915B2@microsoft.com...
> Hi,
>
> 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?
>
>
> "Gudge" wrote:
>
>> 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 s.....
>>
>>
>>
>> "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_s ql.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_s ql.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 would be appreciated.
>> >
>> > --
>> > Greg

Hi,

I've had to copy the files mssqlsystemresource1.mdf, distmdl.ldf and
distmdl.mdf as well.
Now it works.

Regards,
Christian

"Ekrem Önsoy" wrote:

> Chris,
>
> 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" <ChrisfromGermany@discussions.microsoft.com> wrote in
> message news4E8C4D1-4D1F-4766-9636-2E35A1E915B2@microsoft.com...
> > Hi,
> >
> > 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?
> >
> >
> > "Gudge" wrote:
> >
> >> 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 s.....
> >>
> >>
> >>
> >> "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_s ql.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_s ql.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 would be appreciated.
> >> >
> >> > --
> >> > Greg
>

So you confirm that this is a workaround for this specific problem, right?

So, Greg also can use this workaround to solve his issue.

Thanks for the feedback.

--
Ekrem Önsoy



"Chris from Germany" <ChrisfromGermany@discussions.microsoft.com> wrote in
message news:4CA44696-F121-4F5D-A0D6-5691374D075D@microsoft.com...
> Hi,
>
> I've had to copy the files mssqlsystemresource1.mdf, distmdl.ldf and
> distmdl.mdf as well.
> Now it works.
>
> Regards,
> Christian
>
> "Ekrem Önsoy" wrote:
>
>> Chris,
>>
>> 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" <ChrisfromGermany@discussions.microsoft.com> wrote
>> in
>> message news4E8C4D1-4D1F-4766-9636-2E35A1E915B2@microsoft.com...
>> > Hi,
>> >
>> > 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?
>> >
>> >
>> > "Gudge" wrote:
>> >
>> >> 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 s.....
>> >>
>> >>
>> >>
>> >> "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_s ql.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_s ql.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 would be appreciated.
>> >> >
>> >> > --
>> >> > Greg
>>

Have the same error. Have tried the same things - no success. Does anyone have another thought on this?
Thanks,
MG