Linked Server Between Domains

All
How do I go about setting up a linked server between a SQL Server 2000
instance in Domain1 to a SQL Server 2000 instance in Domain2. There is a
trust between the two domains and when I log onto the server in Domain1 I can
connect to the server in Domain2.
Any assistance would be appreciated.
Thanks
Hi David
If you wish to use windows authentication to access domain2 from domain1
then there needs to be a trust between the two domains. It may be easier to
get this working with query analyser first.
With your linked server you can use sp_addlinkedsrvlogin to map logins see
Books online or
http://msdn.microsoft.com/library/de...erver_24tv.asp for more.
Also make sure that msdtc is working correctly on both servers if you are to
make changes to data.
John
"David" wrote:

> All
> How do I go about setting up a linked server between a SQL Server 2000
> instance in Domain1 to a SQL Server 2000 instance in Domain2. There is a
> trust between the two domains and when I log onto the server in Domain1 I can
> connect to the server in Domain2.
> Any assistance would be appreciated.
> Thanks