FIX: DocErr: Incorrect w/ Respect to Valid Login ID Characters

ID: Q128566

The information in this article applies to: BUG# NT: 8540 (4.21)

SYMPTOMS

On page 48 of the Microsoft SQL Server version 4.21 SQL Administrator's "User's Guide" it says that the 'at sign' (@) character can be used as the first character of a user's Login ID. The help screen under the SQL Administrator utility's Add Login screen says that the only valid first character is a letter.

WORKAROUND

The only valid characters for the first character in a Login ID are any letter, the number sign (#), and the underscore (_) character.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft SQL Server version 4.21 documentation. The SQL Server version 6.0 Books Online, SQL Server Administrator's Companion, Part 4, Chapter 9, "Managing SQL Server Logins," Summary of Login ID Information, shows the correct data.

Additional query words: Windows NT

Keywords          : kbenv kbbug4.21 kbfix6.00 SSrvWinNT 
Version           : 4.21 4.21a
Platform          : WINDOWS

Last Reviewed: May 1, 1997