Microsoft KB Archive/323596

= PRB: You Can Only Use the Sp_grantlogin Stored Procedure with Windows NT Group Names That Are Less Than or Equal to 63 Characters =

Article ID: 323596

Article Last Modified on 10/16/2003

-

APPLIES TO


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

-



This article was previously published under Q323596



SYMPTOMS
If you specify a Microsoft Windows NT group name as an argument that is greater than 63 characters in length, the sp_grantlogin stored procedure does not run successfully, and you receive the following error message:

Server: Msg 15401, Level 11, State 1, Procedure sp_grantlogin

Windows NT user or group 'DOMAIN\NT_GROUP_NAME' not found. Check the name again.

Because SQL Server Enterprise Manager uses the sp_grantlogin stored procedure to grant logon permission to Windows NT groups, you also receive the same error message in SQL Server Enterprise Manager if you grant logon permission to a Windows NT group name that is greater than 63 characters in length.



CAUSE
This issue occurs because, for Windows NT group names, the sp_grantlogin stored procedure only accepts names that are less than or equal to 63 characters.



WORKAROUND
To work around this issue, shorten the Windows NT group name to 63 characters or less before you run the sp_grantlogin stored procedure.

Keywords: kbprb kbpending KB323596

-

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

© Microsoft Corporation. All rights reserved.