Configuring Replication on Always ON Database

Hi Mates,

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

USE distribution;
GO
DECLARE @redirected_publisher sysname;
EXEC sys.sp_validate_replica_hosts_as_publishers
        @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

Error Message:

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.