Hi,
AG Name: AG1
Primary Replica: R1
Secondary Replica: R2
Listener: L1
Linked server created on: S1(not a clustered server)
On S1, I want to create a linked server to L1 to make Write operations work even after failover.
I have done exhaustive research but nothing provides a valid method of doing this(after afilover). Can someone please help me to do this ?
Currently, after failover, it gives error as "Failed to update database xxxx because it is readonly