Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQLSERVER_21892

SQL Server 2012

Product Name

SQL Server

Product Version

11.0

Product Build Number

11.00.0000.00

Event ID

21892

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

SQLErrorNum21892

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.