Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_21871

Product Name

SQL Server

Event ID

21871

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

SQLErrorNum21871

Message Text

Publisher %s of database %s has not been redirected.

sp_validate_replica_hosts_as_publishers checks the table MSredirected_publishers in the distribution database for an entry for the identified publisher and publisher database. sp_validate_replica_hosts_as_publishers returns error 21871 when no entry is found.

sp_validate_replica_hosts_as_publishers is only relevant for redirected publishers. If the publisher database is a member of an availability group, use the stored procedure sp_redirect_publisher to associate the publisher and publisher database with the Availability Group Listener Name of the availability group.

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

Community Additions

ADD
Show:
© 2014 Microsoft