Hi, all
In domain A I have Server1(sql 7),
Server2(sql 2000).
In domain B I have Server3(sql 2000) with two instances(Red and Blue). Both instances' ports are not 1433.
My goal is adding Server3\Blue as a linked server in both Server1 and Server2.
In Server2 I added Server3\Blue as a linked server successfully by specified alias and port number.
But I failed in Server1.
I got 'unable to connect to specified server' error.
Any idea?
Thanks in advance,