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).
Details
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 is returned when execution of the stored procedure sp_helpdistributor 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.