We migrated ourÃÂ production SQL Server 2000 database to a new machine and all seems to be working well except for our linked server on our SQL Server 2005 instance that points to our SQL Server 2000 database that was just moved.ÃÂ We get the following error when we try to query a table on the 2000 database.ÃÂ I have read this article in the Books online but that does not seem to apply to us ( http://msdn2.microsoft.com/en-us/library/ms175496.aspxÃÂ ).
OLE DB provider "SQLNCLI" for linked server "SQLPRD-DBS" returned message "Communication link failure".
Msg 233, Level 16, State 1, Line 0
Named Pipes Provider: No process is on the other end of the pipe.
Msg 18456, Level 14, State 1, Line 0
Login failed for user 'sa1'.
Anyone have any ideas?
View Complete Post