November 12, 2007 at 1:04 am
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?
November 12, 2007 at 3:42 am
Hi,
You will need to ensure ports 1433 and 1434 are open on your firewall between servers, otherwise SQL Server will not be able to communicate. In case you have changed from default ports, check SQL Server error log to see what the listener ports are and check with network team to see if firewall rules are preventing traffic from flowing between servers. Although you can ping servers via DNS, this doesn't mean the firewall is allowing SQL Server traffic.
Thanks,
Phillip Cox
November 13, 2007 at 11:27 pm
check if you are able to coonect to the remote server from the client server machine. this could be a netwotrk/permission/firewall problem.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply