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


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q245768

SYMPTOMS

When adding an existing Windows NT logon account as a login in SQL Server you receive the following 15401 error:
Error 15401
Windows NT user or group 'Domain_name\User_name' not found.
Check the name again.

CAUSE

SQL Server is installed with a case-sensitive Unicode collating sequence.

WORKAROUND

By typing user name or group name exactly as it has been entered in User Manager for Domains (including using the original case for each letter), you will be able to add this new login in SQL Server. You can copy and then paste this name from the User Manager for Domains to SQL Server Enterprise Manager.

MORE INFORMATION

This behavior is only linked to Unicode case sensitivity; modifying the sort order has no effect.

Steps to Reproduce the Problem

  1. Install SQL Server with a case-sensitive collating sequence for Unicode. Be sure to clear the Case Sensitive check box located next to the Unicode Locale Identifier list box.
  2. Use the Windows NT User Manager for Domains to create a new user named Domain_name\Test. Type this user name with both upper and lower case letters.
  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 new user name that you created in step 2:

    Domain_name\TEST

    Be sure to type this user name using only upper case letters. You will 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'
    You will 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.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbprb KB245768
©2003 Microsoft Corporation. All rights reserved.