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 Submitted By Gaurav Arora On 12/2/2009 10:08:16 AM Tags: Interview Questions   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 <parameters> 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. Recent FAQs How to Run your Asp.net site from root “/” location (in url) instead of using project directory in Visual Studio 2005, 2008, 2010? What is the connection string to connect to Excel sheet with .xls and .xlsx extension in ASP.Net ? What is difference between UniqueID and ClientID in ASP.Net Controls ? How to use App.Config (Application Configuration) in Console Application or Windows Application in C# ? What is the connection string when you use SQL express database in App_Data in ASP.Net ? View All FAQs..