Export (0) Print
Expand All

MSSQLSERVER_21889

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Show:
© 2015 Microsoft