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;
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.


S_DBA said…
You've mentioned that the solution was to change the property "RPC OUT" to true. But which Linked server should this change be made for?
The linked server that is created while running this sp and is temporary and doesn't persist and the name of the linked server that you've specified in the post is this temporary one. Changing the property of the temporary linked server is useless and is also not possible.
Okay to make you clear whenever you configure Replication SQL Server internally creates Linked Servers. I am not creating any temporary linked servers the change what I made are on the ones that was created by SQL Engine itself. Unfortunately I don't have the setup to show the screenshot. If time permits I will do.
S_DBA said…
Thank you for the response. I'm surprised the linked servers created by SQL Server at the time you configured a Remote Distributor, didn't already have RPC Out set to True. That was the case for me anyway.
Thanks again.