SQLTeam.com | Weblogs | Forums

ODBC Connection link Failure


#1

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.


#2

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