FIX: Security Mgr with Long Group Names Can Cause SQL Shutdown

• Microsoft SQL Server versions 6.0, 6.5

SYMPTOMS

Enumerating members of a group with a long name in SQL Security Manager by clicking the group can cause SQL Server to shut down because of an unhandled exception. Executing the extended stored procedure xp_logininfo to find the members of the same group can also cause this behavior.

CAUSE

The problem occurs when a local group is granted access to SQL Server, that local group contains a global group, and the number of characters of the following items exceeds 55 characters:

   Domain of the local group
   Local group name
   Domain of the global group
   Global group name 

WORKAROUND

Rename either the global group or the local group to a shorter name so that the items listed in the CAUSE section of this article do not have names that exceed 55 characters.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0.

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

The following character limits exist in Windows NT:

   Item                Maximum characters
   -----------------   ------------------
   domain name         15
   machine name        15
   global group name   15
   local group name    256 

Additional query words: prodsql sql6 xp_logininfo SQSECMGR.EXE winnt

Keywords          : kbinterop kbtool SSrvAdmin kbbug6.50 kbfix6.50.SP5 kbbug6.00 
Version           : winnt:6.0,6.5
Platform          : winnt 
Issue type        : 

Last Reviewed: April 21, 1999