Microsoft KB Archive/155556

= FIX: No Information Returned by xp_logininfo =

Article ID: 155556

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q155556





SYMPTOMS
The extended stored procedure XP_LOGININFO reports the privilege level and the permission path by which a Windows NT user account has access to SQL Server. However, for a domain user (for example, Domain\SQLUser) belonging to a global group (for example, SQLGlobal), "xp_logininfo SQLUser" doesn't return any information if "SQLUser" is granted user level privilege through this global group (xp_grantlogin 'Domain\SQLGlobal', 'user'). Similarly, if the global group is added as a member of a local group (for example, SQLLocal) on the Windows NT server where SQL Server resides and user level privilege is granted to "SQLUser" through the local group "SQLLocal" (xp_grantlogin sqllocal, 'user'), 'xp_logininfo SQLUser' does not return any information either.

In both cases, searching the user's permission path in security manager to "verify permissions for account" and "Find all permissions for account" does not return any information.



WORKAROUND
In Windows NT User Manager for Domain, add domain users directly to a local group. You should now be able to grant this group user-level privilege through SQL Security Manager or xp_grantlogin.



STATUS
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
As a side effect of this problem, all SQL Server logins created for Windows NT users granted access through a global group (SQLGlobal above) will show as orphaned logins in Security Manager under Security/Search/Find orphan SQL Login IDs.

Additional query words: prodsqlIntegrated Security

Keywords: kbbug kbfix kbnetwork KB155556

-

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

© Microsoft Corporation. All rights reserved.