Linked Server cannot be found
-
2 weeks ago this was working:
Server A on Win 2000 Mixed Authentication
Server B on Win 2000 Mixed Authentication
Server B linked to Server A using context of a specific username and password
Suddenly this week it fails
If I open Query Analyser (Server A) using Windows Auth
my query of Server B works
If I open Query Analyser (Server A) using a SQL Id and pass
my query of Server B fails with:
Server: Msg 17, Level 16, State 1,
Procedure ul_QuickListT, Line 11
SQL Server does not exist or access denied.
Any Ideas?
-
Hi,
Firstly, I will check if the username that is used for the linked server connection exists on the target machine of the linked server.
Secondly, Try to open the Enterprise Manager->Security->Linked Servers. Check if the linked server of B or A is still there... if yes... try to click on the Tables. If not try to recreate the linked server.
Cheers
-
This error message is not related to the logins.
This error message means that the second server may be off line or the firewall port was closed. Please, try to ping the second server from the first server. If it does not ping escalate to your network admins.
If it would ping try to connect to it just using Query Analyzer directly without any linked server. If this does not work but you still can ping it then the machine is up but SQL Server on it is down or they closed port 1433. Escalate to your network admins too.
Is it a named instance? if it is, let us know.
What network library are you using? Named Pipes or TCP/IP. If named pipes works and TCP/IP does not, then it is a port issue. Is it the same port on Server 2 and in the Client Network Utility on Server 1?
Yelena
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply