Today we are going to explore on how to configure replication on Always ON Database. There are few blogs which explained step by step.
I followed the same instructions and the only difference is I have setup Multi Subnet ALWAYS ON.
While running the below stored procedure I got the below error
DECLARE @redirected_publisher sysname;
@original_publisher = 'node100',
@publisher_db = 'AGREPLTEST',
@redirected_publisher = 'AGREPLLISTNR';
My setup for reference:
NODE100 : Primary Replica and publisher
NODE200: Secondary Replica
NODE300: Distributor and Subscriber Server
OLE DB provider "SQLNCLI11" for linked server "[BEF84991-4461-4578-B0B0-7D1CD024E276]" returned message "Unable to complete login process due to delay in opening server connection".
Msg 21892, Level 16, State 1, Procedure sp_hadr_validate_replica_hosts_as_publishers, Line 67
Unable to query sys.availability_replicas at the availability group primary associated with virtual network name '[Listener Name]' for the server names of the member replicas: error = 7303, error message = Error 7303, Level 16, State 1, Message: Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "[BEF84991-4461-4578-B0B0-7D1CD024E276]"..',
Solution: This can be avoided by changing the Linked Server property RPC OUT to true.