Permissions error while upgrading to SP2 CTP...

Hi Folks,

I have a request from one of our researchers to upgrade to CTP SP2. I am getting the error message:

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.

I added server\administrators - full control to the permissions of \Data\, but it still does not work.

Has anyone else ran into this, and how do I fix it?

Thanks,

Alainna

[651 byte] By [Alainna] at [2007-12-27]

«« uninstall
»» BizDesk: Internet Explorer cannot open the Internet site file://.....hta

# 1

Error 29506. SQL Server Setup failed to modify security permissions on file E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user administrator.

The problem is that there exists a file in this Data directory that the user running SP1 does not have permissions to modify. The workaround is to figure out which file this is (typically a user created DB or some backup program files) and to temporarily assign permission to that file(s). You can revert back to the intended permissions after running SP1.

Thanks,
Sam Lester (MSFT)

SamuelLester-MSFT at 2007-9-3 >

top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...

# 2

Sam,

Thank you, that worked. I have no idea why I didn't check the files before posting, but thank you!

- Alainna

Alainna at 2007-9-3 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Permissions error while upgrading to SP2 CTP......'

Permissions error while upgrading to SP2 CTP...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified