Problem installing SP2

having an issue installing sp2, ive looked around for other solutions but
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (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_KB921896_sqlrun_s ql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is 0
Action ended 08:54:08: InstallFinalize. Return value 3.
Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (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_KB921896_sqlrun_s ql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>
|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
)
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>
|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
[url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>
|||cheers john,
I went throo the files (slow friday ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> [url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>
|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>
|||hi john,
worked great - sorted it all today,
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>