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

• Microsoft SQL Server version 7.0

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.

Additional query words: Security Windows NT Users Groups Login

Keywords : SSrvAdmin kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbprb