all groups > sql server replication > february 2004 >
You're in the

sql server replication

group:

xp_logininfo returns error for NT logins on trusted domain



xp_logininfo returns error for NT logins on trusted domain JohnB
2/20/2004 8:29:40 AM
sql server replication: 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
RE: xp_logininfo returns error for NT logins on trusted domain Paul Ibison
2/20/2004 9:26:05 AM
No guarantees, but I remember seeing this article. Hopefully it might help
http://support.microsoft.com/?id=24164
Regards
RE: xp_logininfo returns error for NT logins on trusted domain JohnB
2/23/2004 12:34:17 AM
Unfortunately the Pre-Windows 2000 Compatible Access Group
is part of Active Directory, which my customer does not use
So the workaround is no good for me.
Thanks anyway
AddThis Social Bookmark Button