xp_logininfo returns error for NT logins on trusted domain

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JohnB (anonymous_at_discussions.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 08:29:40 -0800

I am setting up SQLServer replication between servers on
different domains which have a two way trust.

The publishing servers are a mixture of NT and Windows 2000
The subscribibg server is Windows 2000.

I have no problem subscribing to the publications on the NT
servers. The trust allows me to create a SQLServer login
on the publisher which is the NT account that runs the
SQLServer service on the subscriber. Replication works OK.

When I try to subscribe to the publications on the Windows
2000 servers, I get the follwing error message when
browsing
for the publication:
Error 8198: Could not obtain information about Windows NT
group/user 'DOMAIN\user'

I can reproduce this problem outside of replication.
If I add a SQLServer account which is any login on the
other domain. Even though Enterprise Manager lets me create
this login (and validates it), the same error occurs when
the stored procedure xp_logininfo executes:
Server: Msg 8198, Level 16, State 24, Procedure
xp_logininfo, Line 58
Could not obtain information about Windows NT
group/user 'DOMAIN\user'.

This error happens if I create a SQLServer login for any
NT account on any other trusted domain. It does not happen
if I add a login which is an NT group.

I have found technet articles about this error but none of
them apply to this particular scenario. One article says
that this error can happen if the domain name is the same
as a computer on the domain. This is not the case for me as
I have tried all trusted domains and get the same error.

If anyone has had this problem and knows how to get round
it...please let me know.

Relevant Pages

  • Re: ADMIN Account Issue
    ... Can you actually login to one of the DCs at its console? ... the Default Domain Controllers Policy under Windows Settings->Security ... > Terminal Services in Administrative mode NOT Application mode. ... > when trying to RDP to any of the DC servers I get a message that says: ...
    (microsoft.public.win2000.active_directory)
  • Re: Administrator Password - Question
    ... Sometime back, I had to change the password for Administrator, and I did ... the servers using neither the hold or the new password. ... Step 1: Start Windows PC ... When you can see the Windows login screen, ...
    (microsoft.public.win2000.security)
  • Intranet connect to SQLServer Under users account.
    ... I'm trying to set up an intranet where people login under their own windows ... On a test webpage I can output the user account being used: ... SQLServer using their account. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: Linked Server
    ... I’ve got two servers, say ServerA and ServerB, that are Windows 2000 Adv'd ... their Windows login mapped into a Domain level group, ... This works except for one thing: I cannot get the linked servers to work. ...
    (microsoft.public.sqlserver.security)
  • RE: Clock does not keep correct time
    ... if you login to a domain check the times on the servers are they accurate since Windows does synchronize with servers if it is in a domain and users login in to the domain. ... If the servers are incorrect set them to the correct time. ...
    (microsoft.public.windowsxp.general)