We running SQL 2005 on Windows 2003. When I created a link to a server the process works fine. The next day I get this error and the process does not run.
Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'LAB\DSHSNBSTEST$'. [SQLSTATE 28000] (Error 18456) TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 42000] (Error 10054) OLE DB provider "SQLNCLI" for linked server "DSHSPENBSTEST" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed.
Any help would be greatly appreciated.