Edit

MSSQLSERVER_21892

  • Article

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
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.'

Explanation

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 one of the first uses 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.

User Action

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.