| title | MSSQLSERVER_21889 | |
|---|---|---|
| description | MSSQLSERVER_21889 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| ms.date | 04/04/2017 | |
| ms.service | sql | |
| ms.subservice | supportability | |
| ms.topic | reference | |
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
| 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. |
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.
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.