Installing SQL 2008 Feb CTP on a VPC

calendarMar 16, 2008 · 1 min read · Uncategorised  ·
Share on: linkedincopy

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:windowssecuritytemplatessetup security.inf" /verbose

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

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