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.

Article by Gaurav Aroraa
Gaurav is a Microsoft Technology Specialist professional. He has awarded lifetime membership from Computer Society of India (CSI). He has more than 13yrs of experience in the industry. Currently, he is working in the capacity of Solution Architect with an MNC. He is serving to the various communities since 1999.

Follow Gaurav Aroraa or read 149 articles authored by Gaurav Aroraa


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: