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)