Microsoft small business knowledge base

Article ID: 233161 - Last Review: February 24, 2004 - Revision: 4.2

This article was previously published under Q233161
BUG #: 55139 (SQLBUG_70)

On This Page


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
  1. Use Windows NT User Manager for Domains to create a new user account with the name "USER1".
  2. 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").
  3. Add the user you created in step 1 above to this newly-created group.
  4. Execute the following script:
    use master
    xp_grantlogin 'TEST1\USER1'
    xp_logininfo 'TEST1\USER1'
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'.

  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
kbbug kbpending KB233161
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support