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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbpending kbprb KB323596
©2003 Microsoft Corporation. All rights reserved.