Microsoft KB Archive/245768

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

Article ID: 245768

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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 ' ' 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
 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. Use the Windows NT User Manager for Domains to create a new user named \Test. Type this user name with both upper and lower case letters. In SQL Server Enterprise Manager, right-click the Logins icon in the Security folder, and then click New Login on the shortcut menu. In the Name dialog box, type the new user name that you created in step 2:

\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 ' \TEST' not found.

Check the name again.

  In Query Analyzer, run the following query: exec master..sp_grantlogin '\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 ' \TEST' not found. Check the name again.

</li></ol>

Additional query words: Security Windows NT Users Groups Login

Keywords: kbprb KB245768

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.