Edit

MSSQLSERVER_21889

  • Article

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
Event ID 21889
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name SQLErrorNum21889
Message Text The SQL Server instance '%s' is not a replication publisher. Run sp_adddistributor on SQL Server instance '%s' with distributor '%s' in order to enable the instance to host the publishing database '%s'. Make certain to specify the same login and password as that used for the original publisher.

Explanation

In order to host the publisher database, the instance of SQL Server must be a replication publisher. sp_validate_redirected_publisher calls sp_helpdistributor at the remote server to determine whether the server is a replication publisher. This error indicates that the target instance of SQL Server is not a replication publisher.

User Action

Execute sp_adddistributor at the instance of SQL Server that hosts the publisher database. When running sp_adddistributor, specify the correct distributor. Use the same value for the @password parameter as that used when sp_adddistributor was initially run at the distributor.