+ Reply to Thread
Results 1 to 4 of 4

Setup has detected a non canonical discretionary access control li

  1. 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.


  2. 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.



    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

  3. Re: Having the same problem

    (Martin Beechen) writes:
    > 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.


    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, esquelatsommarskogdotse

    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


  4. Update: Got it working

    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

+ Reply to Thread