21892

Product

Name

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

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.

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

, the linked

server used by

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

ﾉ

Expand table