Sample Header Ad - 728x90

Linked Server Connection Issue to SQL Server AlwaysOn Listener

0 votes
0 answers
1059 views
I have SQL Server 2008R2 Standard Edition. I am making a Linked Server connection to a Listener of an AlwaysOn Availability Group. However, when I run a query from SSMS I intermittently get this error: OLE DB provider "SQLNCLI10" for linked server "Listener,4600" returned message "Unable to complete login process due to delay in opening server connection". Msg 7303, Level 16, State 1, Line 7 Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "Listener,4600". I thought it may be a driver issue but OLE DB looks to be installed. Any idea what I may be missing? enter image description here
Asked by K09 (1454 rep)
Nov 15, 2021, 07:38 PM