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 ca
n
connect to the server in Domain2.
Any assistance would be appreciated.
ThanksHi 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
ver_24tv.asp" target="_blank">http://msdn.microsoft.com/library/d...>
ver_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