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
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
Don't see what you're looking for? Try a search.
|