I am getting the following message when running a query using a linked server
OLE DB provider "SQLNCLI" for linked server "server\instance" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18456, Level 14, State 1, Line 0
Login failed for user 'sa'.
The linked server is SQL 2000 and the server running the query is SQL 2005