MSSQLSERVER_21871
Details
Product Name |
SQL Server |
Product Version |
11.0 |
Product Build Number |
11.00.0000.00 |
Event ID |
21871 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
SQLErrorNum21871 |
Message Text |
Publisher %s of database %s has not been redirected. |
Explanation
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.
User Action
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.