Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_21889

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.

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 is returned when execution of the stored procedure sp_helpdistributor indicates that the target instance of SQL Server is not a replication publisher.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft