This posting is related to "SQL Server 2008 Standard Edition on windows XP".

I have the problem both when installing SQL Server 2008 Standard Edition on
Windows XP Pro as well on windows Vista Business.

Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\100\COM\'. Please veirfy
your security settings and make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL
Server\MSAS10.SQL2008\OLAP\bin\'. Please veirfy your security settings and
make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\MSAS1°.SQL2008\OLAP\'.
Please veirfy your security settings and make corrections if needed.

I'm completely lost where to look for to solve this problem.
Thanks.

I'm having this same problem with SQL Server 2008 R2. I get a warning when installing that has this message, and and any time I start SQL Server Management Studio the message appears and prevents Management Studio from running.

I have no idea how to go about fixing this. Hoping someone on here can provide some insight, or at least point me in the right direction.



Gu wrote:

Setup has detected a non canonical discretionary access control li
24-Dec-08

This posting is related to "SQL Server 2008 Standard Edition on windows XP".

I have the problem both when installing SQL Server 2008 Standard Edition on
Windows XP Pro as well on windows Vista Business.

Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\100\COM\'. Please veirfy
your security settings and make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL
Server\MSAS10.SQL2008\OLAP\bin\'. Please veirfy your security settings and
make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\MSAS1??.SQL2008\OLAP\'.
Please veirfy your security settings and make corrections if needed.

I'm completely lost where to look for to solve this problem.
Thanks.

Previous Posts In This Thread:

On Wednesday, December 24, 2008 6:46 AM
Gu wrote:

Setup has detected a non canonical discretionary access control li
This posting is related to "SQL Server 2008 Standard Edition on windows XP".

I have the problem both when installing SQL Server 2008 Standard Edition on
Windows XP Pro as well on windows Vista Business.

Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\100\COM\'. Please veirfy
your security settings and make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL
Server\MSAS10.SQL2008\OLAP\bin\'. Please veirfy your security settings and
make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\MSAS1??.SQL2008\OLAP\'.
Please veirfy your security settings and make corrections if needed.

I'm completely lost where to look for to solve this problem.
Thanks.


Submitted via EggHeadCafe - Software Developer Portal of Choice
A MongoDb Cache Utility
http://www.eggheadcafe.com/tutorials...e-utility.aspx

(Martin Beechen) writes:
I would try right-clicking the directories mentioned in the error
messages and fiddle around with the permissions and OK, and hope
that fixes the ACLs.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

So I finally got this working. I'm still not sure what the "non-canonical" verbiage is referrring to, but here' s how I was able to fix it in my environment.

Its ultimately a security issue that seems to result from having 1 version of SQL Server installed (in this case SQL Server 2008 Express) and then installing another instance in addition to it (in my case, SQL Server 2008 Developer). Something happens with the directories that the two instances share that causes a security problem.

If you navigate to the directory in question, right click it, and open up the security options tab, you'll likely find that the account you're logged in as doesn't have full control over the directory. Edit the settings for your account to have full access and you should be good to go. Worked for me on Win 7 x64.



Gu wrote:

Setup has detected a non canonical discretionary access control li
24-Dec-08

This posting is related to "SQL Server 2008 Standard Edition on windows XP".

I have the problem both when installing SQL Server 2008 Standard Edition on
Windows XP Pro as well on windows Vista Business.

Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\100\COM\'. Please veirfy
your security settings and make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL
Server\MSAS10.SQL2008\OLAP\bin\'. Please veirfy your security settings and
make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\MSAS1??.SQL2008\OLAP\'.
Please veirfy your security settings and make corrections if needed.

I'm completely lost where to look for to solve this problem.
Thanks.

Previous Posts In This Thread:

On Wednesday, December 24, 2008 6:46 AM
Gu wrote:

Setup has detected a non canonical discretionary access control li
This posting is related to "SQL Server 2008 Standard Edition on windows XP".

I have the problem both when installing SQL Server 2008 Standard Edition on
Windows XP Pro as well on windows Vista Business.

Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\100\COM\'. Please veirfy
your security settings and make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL
Server\MSAS10.SQL2008\OLAP\bin\'. Please veirfy your security settings and
make corrections if needed.
Setup has detected a non canonical discretionary access control list (DACL)
on directory 'c:\Program Files\Microsoft SQL Server\MSAS1??.SQL2008\OLAP\'.
Please veirfy your security settings and make corrections if needed.

I'm completely lost where to look for to solve this problem.
Thanks.

On Tuesday, June 22, 2010 6:08 PM
Martin Beechen wrote:

Having the same problem
I'm having this same problem with SQL Server 2008 R2. I get a warning when installing that has this message, and and any time I start SQL Server Management Studio the message appears and prevents Management Studio from running.

I have no idea how to go about fixing this. Hoping someone on here can provide some insight, or at least point me in the right direction.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 POCO-First development and POCO Template
http://www.eggheadcafe.com/tutorials...-template.aspx