ITsVISTA
Information that makes life easier when it comes to installing, managing, and using Windows Vista.
Start About FAQ Blogroll Shop

ITsVISTA KB-Link: KB2456741

You cannot create an Authorization Manager SQL store in a SQL Server 2008 R2 database that has a case-sensitive collation in Windows Server 2008 R2, in Windows 7, in Windows Vista, or in Windows Server 2008

Consider the following two scenarios:

Scenario 1

  • You have a computer that is running one of the following operating systems:
    • Windows Vista
    • Windows Server 2008
    • Windows 7
    • Windows Server 2008 R2
  • You select an existing SQL database to create an Authorization Store in the Authorization Manager.
  • The specified SQL database has a case-sensitive collation.

Scenario 2

  • You have a computer that is running one of the following operating systems:
    • Windows Vista
    • Windows Server 2008
    • Windows 7
    • Windows Server 2008 R2
  • You select a nonexistent SQL database to create an Authorization Store in the Authorization Manager. In this case, the Authorization Manager creates the specified SQL database by using the same collation as the instance of SQL Server.
  • The instance of SQL Server has a case-sensitive collation.

In these two scenarios, the operation fails, and you receive an error message that resembles the following:

Cannot create a new authorization store. The following problem occurred: Access is denied.

There is a download that resolves this issue. See Hotfixes for details.
32-bit Download: Contact Microsoft
64-Bit Download: Contact Microsoft

For more information on this issue, including potential causes, workarounds, and resolutions, see: Microsoft KB Article KB2456741.

Get notified of new posts for FREE via RSS or E-mail

Subscribe to ITsVISTA!

Related Posts