Microsoft KB Archive/233161

= BUG: Xp_logininfo Returns Error 8198 =

Article ID: 233161

Article Last Modified on 2/24/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q233161



BUG #: 55139 (SQLBUG_70)



SYMPTOMS
If a Microsoft Windows NT local or global group has the same name as the domain, the computer, or another domain with trusts established, the xp_logininfo extended stored procedure returns error 8198 when it is executed for a Windows NT user of that local or global group.



WORKAROUND
To work around this problem, do either of the following:
 * Change the Windows NT local or global group name.

-or-
 * Remove the user from that local or global group.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Problem
NOTE: This example assumes the following:
 * Domain name = TEST1
 * Local/global group name = test1
 * Windows NT user account name = USER1

 Use Windows NT User Manager for Domains to create a new user account with the name "USER1". Also use User Manager for Domains to create a local or global group that has the same name as the Domain (in this example, "test1"). Add the user you created in step 1 above to this newly-created group.  Execute the following script: use master go

xp_grantlogin 'TEST1\USER1' go

xp_logininfo 'TEST1\USER1' go 

You will receive the following error message:

Server: Msg 8198, Level 16, State 10, Procedure xp_logininfo, Line 58

Could not obtain information about Windows NT group/user 'test1'.

Keywords: kbbug kbpending KB233161

-

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

© Microsoft Corporation. All rights reserved.