Tips and Tricks : Creating Linked Server to an Availability Group Listener with ReadOnly routing
'In my recent interaction with customer, I was asked if linked server can be created to an availability group listener? My immediate response was “Yes”. Next question was immediately thrown at me that if they can redirect this listener to secondary replica? This time my little delayed response was – Yes. Provided we use proper connection string. Here is the linked server creation script
EXEC sp_addlinkedserver @server = N'MyLinkedServer'
,@provider = N'SQLNCLI'
,@srvproduct = N'SqlServer'
,@datasrc = N'MyListener'
,@provstr = N'ApplicationIntent=ReadOnly'
…and it was not working as they expected.'...
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt