June 4, 2008 at 4:11 am
I've run into a problem in upgrading my SQL Server 2005 Enterprise SP1 to service pack 2. All components upgrade (reporting services, analysis services, int services) except the database engine, which fails with error from failure summary:
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 [username]. 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.
the user running the install is a local admin with permissions on the named path.
Any suggestions?
June 4, 2008 at 4:26 am
Can you check the permission to the database files in the path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for the user with which you are running the setup. I think the user might have permission to the Data folder but not to the individual files..
[font="Verdana"]- Deepak[/font]
June 4, 2008 at 8:07 am
The user running install has permissions on all files within the directory named.
In Security in Event Viewer there is a Failure Audit at the time this happens for user SYSTEM. I noticed the Caller User Name is"[SERVERNAME]$" as though a username is missing after the "$". What could cause this? Could it be a config issue on the server?
June 5, 2008 at 2:33 am
You were right Deepak. Despite SQL Server being installed initially with Reporting Services at same time permissions were missing on RStempDB.mdf and .ldf for Local Administrators group, given to Local Administrator user instead.
Added permissions and SP2 installed fine
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply