MSSQLSERVER_21871
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| 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. |
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for