May 21, 2014 at 12:28 pm
i am trying to configure linked server on one of my test server to alwayson group replicas. I tried to create linked server with listener but it's not working. do we have to configure linked server for each replicas ? From msft site-
For distributed transactions: After a failover, the new principal server/primary replica is unable to connect to the distributed transaction coordinator on the previous principal server/primary replica. Therefore, the new principal server/primary replica cannot obtain the transaction status.
May 23, 2014 at 9:35 am
Use the listener. Can you put the error you get when you try the Listener?
I have linked servers setup in my AO SQL Servers.
MCSE SQL Server 2012\2014\2016
May 28, 2014 at 11:04 am
I have attached the error below...
May 28, 2014 at 12:16 pm
I figured it out. Thank you.
November 4, 2015 at 9:01 am
... and how did you solve the problem?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply