Microsoft KB Archive/147830

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

Article ID: 147830

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



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

Additional query words: prodsql sql6 xp_logininfo SQSECMGR.EXE winnt

Keywords: kbbug kbfix kbinterop KB147830

-

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

© Microsoft Corporation. All rights reserved.