Cliff Green's Blog

SQL Server 2008 RC0 canonical errors during setup

I was installing the RC0 version of SQL Server 2008 this weekend and kept running into the following error:

This access control list is not in canonical form and therefore cannot be modified.

There were a lot of these errors in the Feb CTP related to the registry which seemed to have been resolved.  The errors from the RC0 install were related to the directory structure and the permissions being out of order.

I was able to resolve the issue by navigating to the %Program Files%\Microsoft SQL Server\100\Setup Bootstrap\Log\ directory and opening the details.txt file to find out the directory that was having the issue.  Using that information I went to the directory, right clicked and went to properties.  By clicking the 'Security' tab the OS warns you of the issue and then fixes it.  Hitting retry at this point allows the installation to continue.

In total there were 5 directories that caused this issue, all of them located in the %Program Files%\Microsoft SQL Server directory structure.  While I didn't capture each of them it is an easy fix that produces a clean install of SQL Server.  Hopefully this will save you some time if you are running into the same problem.  I was installing on Windows Server 2003 EE R2 SP2.

Published Monday, July 07, 2008 2:12 PM by green.cliff
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

a-foton » SQL Server 2008 RC0 canonical errors during setup said:

PingBack from http://blog.a-foton.ru/2008/07/sql-server-2008-rc0-canonical-errors-during-setup/

July 7, 2008 9:55 AM
 

EitanF said:

Great post!  Helped me tremendously!

With your help I was able to install SQL Server Express 2008 x64 RC0 on Windows Small Business Server 2008 RC1 (64-bits).   Here was the step-by-step in my case:

The problem folder was C:\Program Files (x86)\Microsoft SQL Server\100\Shared, and the solution was:

right-click on this folder, go to properties,

click the security tab

click ok on the message that pops up saying the order is wrong

click on "Edit..." & continue on UAC

click Reorder on the next pop-up.

Apply and Ok out of the dialog boxes and then Retry in SQL setup.  

Hope this helps in addition to Cliff's excellent post!

July 24, 2008 5:51 PM
 

Joel Lindstrom said:

Thanks Cliff--solved my problem.

July 28, 2008 9:32 PM
 

Mike said:

Saved my backside too. Thanks Cliff & EitanF!

In my case it was the C:\Program Files (x86)\Microsoft SQL Server\100\\tools folder.

August 2, 2008 6:52 PM
 

John said:

Yes, thanks for the post.  In my case I had lots of different directories with ACLs that were not in 'canonical' form.   I think one can go to a folder several levels higher than where the problem resides, and reset the ACLs on all subdirectories beneath -- this is a slightly faster approach.

September 8, 2008 7:56 PM
 

fandangoameruso@hotmail.com said:

I found i had this problem when trying to install the SQL 2008 express edition and i received the same error message however mine turned out to be a problem with the permissions in the registry.  Looking in that details.txt log file identified the last registry it had tried to write to but had failed,  so i browse to that node in teh registry right clicked on it selected permissions and i then received the "do you want to sort..." pop up to which i clicked yes. I could then re run the installer and all worked perfectly.  

i wouldn't have worked it out without this post so thanks

September 10, 2008 11:02 AM
 

Raviraj said:

Hey, great post!!! Helped me a lot :)

May 1, 2009 12:08 PM
 

Jeff said:

Mine was a problem with the registry as well

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

Browsed there, right clicked on Perflib, selected permissions, clicked ok on the popup notice, and it worked.  Thanks everyone, especially fandangoameruso

July 13, 2009 12:43 PM
 

Sushila said:

This post was invaluable - thank you for taking the time to detail the fix. Mine

was the same issue as Jeff's - in the PerfLib folder (but never would have found it if I

hadn't looked at the Detail.txt file)

December 4, 2009 7:10 AM

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required
Submit

This Blog

Syndication

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker