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

The information in this article applies to:

Microsoft SQL Server 6.0
Microsoft SQL Server 6.5

This article was previously published under Q147830

BUG# 13549 (SQLBUG_65 and SQLBUG_60_RW)

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 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

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

Modification Type:	Major	Last Reviewed:	3/14/2006
Keywords:	kbBug kbfix kbinterop KB147830