Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Product Name

SQL Server

Event ID


Event Source




Symbolic Name


Message Text

Unable to query sys.availability_replicas at the availability group primary associated with virtual network name '%s' for the server names of the member replicas: error = %d, error message = %s.',

sp_validate_replica_hosts_as_publishers queries the current primary of the availability group associated with the redirected publisher, to determine the instances of SQL Server that host the member replicas. When this query fails, error 21892 is returned.

sp_validate_replica_hosts_as_publishers is typically on of the first use of the temporary linked server, so if there are connectivity problems they are likely to appear first with sp_validate_replica_hosts_as_publishers. Unlike sp_validate_redirected_publisher, the linked server used by sp_validate_replica_hosts_as_publishers always uses the credentials of the caller when connecting to any of the availability group replica hosts.

When running this stored procedure, made certain that you run from a login that is valid on all of the replicas. The login will require sufficient authorization to query availability group metadata tables as well as to query the subscription metadata tables in the publisher database replica.

Examine the original referenced error to determine the cause of the failure and appropriate corrective action.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft