PRB: Case-Sensitive Unicode Collating Sequence and Windows NT Logins

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article was previously published under Q245768
This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
When you add an existing Windows NT logon account as a Microsoft SQL Server login, you receive the following error message:
Error 15401
Windows NT user or group 'Domain_name\User_name' not found.
Check the name again.
CAUSE
This problem occurs because you install SQL Server by using a case-sensitive Unicode collating sequence.
WORKAROUND
You can add this new login in SQL Server by typing the user name or group name exactly as it is entered in User Manager for Domains. (This includes using the original case for every letter.) You can copy this name from the User Manager for Domains to SQL Server Enterprise Manager.
MORE INFORMATION
This behavior is linked only to Unicode case sensitivity. This behavior does not occur if you only modify the sort order.

Steps to Reproduce the Problem

  1. Install SQL Server by using a case-sensitive collating sequence for Unicode. Make sure that you click to clear the Case Sensitive check box next to the Unicode Locale Identifier list box.
  2. Use the Windows NT User Manager for Domains to create a new user that is named Domain_name\Test. Type this user name by using both uppercase and lowercase letters.

    Note In this user name, Domain_name represents the actual domain name.
  3. In SQL Server Enterprise Manager, right-click the Logins icon in the Security folder, and then click New Login on the shortcut menu.
  4. In the Name dialog box, type the user name that you created in step 2. For example, type the following:
    Domain_name\TEST
    Make sure that you type this user name by using only uppercase letters. By doing this, you receive the following error message:
    Error 15401
    Windows NT user or Group 'Domain_name\TEST' not found.
    Check the name again.
  5. In Query Analyzer, run the following query:
    exec master..sp_grantlogin '<Domain_name>\TEST'
    When you run this query, you receive the following error message:
    Server: Msg 15401, Level 11, State 1, procedure sp_grantlogin, Line 36
    Windows NT user or Group 'Domain_name\TEST' not found. Check the name again.
Security Windows NT Users Groups Login
Properties

Article ID: 245768 - Last Review: 12/05/2015 17:26:06 - Revision: 4.0

Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 R2 Express

  • kbnosurvey kbarchive kbprb KB245768
Feedback