Installing SQL 2008 Feb CTP on a VPC

Published 16 March 08 09:41 PM | Richard

I have been trying to install the Feb CTP of SQL 2008 on an Virtual PC, but kept getting the following error

SQL Server Browser Install for feature 'SQL_Browser_Redist_SqlBrowser_Cpu32' failed with exception System.InvalidOperationException: This access control list is not in canonical form and therefore cannot be modified.

Turns out the problem was that I had run SysInterals NewSID on the VPC as it was based on a diff disk off our standard W2K3 test install and I wanted it not to clash with other test installs. NewSID leaves the registry in a state that causes the SQL installer problems. To get round it you need to run

secedit /configure /db setupsecurity.sdb /cfg "c:\windows\security\templates\setup security.inf" /verbose

as detailed in http://support.microsoft.com/kb/942517.

Once this is done the installer can be run without any problems

Filed under: ,

Comments

# Steve said on April 17, 2008 04:47 PM:

Have you found any side effects of using secedit in this situation to watch out for? I'm not real familiar with secedit but resetting the local security database to default values would seem to have quite a bit of impact. I use NewSID often on my VPCs. Would you recommend always using secedit afterward just to be safe?

# Richard said on April 17, 2008 05:51 PM:

I have had no problems with Virtual PC in question. However it is only a demo/test box so I have not checked too deeply.

At this time I am only running secedit if I have to