July 14, 2006 at 6:40 am
Hi
I have two sql 2000 servers Lets say Server A and Server B. Now I want to make them as linked servers so that queries can be executed fron one server on to the other as it is an application need.
Now I have added both of them as linked server for each other. Now there is one very starnge thing. I'm able to access Server A from Server B and able toexecute quereies but when I try to connect to Server B from Server A it gives me the error that "SQL Server Does not Exist or Access Denied".
Could anyone tell me as to what All i need to check here...
July 14, 2006 at 9:53 am
I saw these cases when the default protocol for the client on one server is TCP/IP and on another server is Named pipes. Port 1433 (or whatever you are using) may be closed. Nambe Pipes port 445 may be open So the client that uses Named Pipes will be able to connect and TCP/IP client will not be able. Also, if one of the servers is a Named Instance you would need port UDP 1434 open or to specify the port explicitly.
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply