Hi,
I am trying to configured Link server under different domain using SQL server 2000.
The server S1 Located at X country and S2 Located at Y country. (S1 is main Server)
I tried DSN connection, which is working fine.
From Enterprise Manager of S1, I could able to fetch query of S2. But when I am configuring for Link server, I am not able to display the objects of S2 such as tables, views.
I am getting “Error 17: SQL Server does not exit or access denied”
Is there any firewall issue for privileges?