OLE DB provider "SQLNCLI" for linked server "remote ip" returned message "Communication link failure
Why should I got this error :
OLE DB provider "SQLNCLI" for linked server "remote ip" 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 18452, Level 14, State 1, Line 0
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Sol. This is known as Linked Server error
Try following steps:
1. exec sp_addlinkedserver
To know moe about sp_addlinkedserver visit:http://msdn.microsoft.com/en-us/library/aa259589(SQL.80).aspx
2. If you still got the problem it means there is something wrong in your account, so, create a new SQL account with new server name and then try.