BUG: Xp_logininfo Returns Error 8198

ID: Q233161


The information in this article applies to:

BUG #: 55139 (SQLBUG_70)

SYMPTOMS

If a Microsoft Windows NT local or global group has the same name as the domain or the computer, 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:


STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.


MORE INFORMATION

Steps to Reproduce the Problem

NOTE: This example assumes the following:
  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:


  5. 
    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'.

Additional query words:


Keywords          : SSrvStProc kbbug7.00 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: May 24, 1999