0

Following the documentation provided (Configure replication with availability groups - SQL Server Always On | Microsoft Docs) I set up an AG-based Distributor (REPLAG) and an AG-based Publisher (PUBAG). I only have two servers to work with so REPLAG involves named instances SRV1\REPLDIST and SRV2\REPLDIST and the PUBAG involves the default instances SRV1 and SRV2.

For REPLAG the named instance and AG Listener are all set up to use port 54321. Everything seems to be OK - it even accepts the "sp_redirect_publisher" call to go from Original Publisher SRV2 to PUBAG without any error. When I run "sp_validate_replica_hosts_as_publishers" the value of @Redirected_publisher comes back as PUBAG (good thing) but I get the following errors:

Msg 21890, Level 16, State 1, Procedure sp_hadr_verify_replication_publisher, Line 95 [Batch Start Line 8] The SQL Server instance 'SRV1' with distributor 'REPLAG, 54321' and distribution database 'distribution' cannot be used with publisher database 'Test'. Reconfigure the publisher to make use of distributor 'SRV2\REPLDIST' and distribution database 'SRV2\REPLDIST. One or more publisher validation errors were encountered for replica host 'SRV1'.

Msg 21890, Level 16, State 1, Procedure sp_hadr_verify_replication_publisher, Line 95 [Batch Start Line 8] The SQL Server instance 'SRV2' with distributor 'REPLAG, 54321' and distribution database 'distribution' cannot be used with publisher database 'Test'. Reconfigure the publisher to make use of distributor 'SRV2\REPLDIST' and distribution database 'SRV2\REPLDIST. One or more publisher validation errors were encountered for replica host 'SRV2'.

It doesn't matter whether I execute the verify procedure in a query on the Listener REPLAG or its Primary Replica SRV2\REPLDIST...the error comes up. I've been battling this for a while and I'm pretty close to giving up on the AG-based Distributor and going with a standalone remote Dist. I tried to search on Error/Msg 21890 but there's nothing out there. Any and all feedback is greatly appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.