This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 55139 (SQLBUG_70)
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.
To work around this problem, do either of the following:
Change the Windows NT local or global group name.
Remove the user from that local or global group.
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 mastergoxp_grantlogin 'TEST1\USER1'goxp_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'.