Please help Linked server giving connection error.

• swaghmare

  Grasshopper

  Points: 15

  More actions

  April 14, 2010 at 10:54 pm

  #233884

  I have a Sql Server job which includes queries that has to be run on the linked server , The job was running successfully till yesterday, Suddenly I got this error , have checked the Sql Remote connection settings it is all fine. Please suggest what must have gone wrong..

  OLE DB provider "SQLNCLI" for linked server returned message "Login timeout expired". [SQLSTATE 01000] (Message 7412) OLE DB provider "SQLNCLI" for linked server returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". [SQLSTATE 01000] (Message 7412)