ODBC Connection link Failure

Hi Team,

Good Morning and Happy Friday, I have an issue with an ODBC
connection on one of my QA server which is refreshing data from Prod using a
linked server. I got the below error message could you guys help me in this..

TCP Provider: The specified network name is no longer
available. [SQLSTATE 42000] (Error 64)
OLE DB provider "SQLNCLI11" for linked server "QAXXXX"
returned message "Communication link failure"

Thank you very much in Advance.

Read through this: https://support.microsoft.com/en-us/kb/942861

1 Like