In this blog post, let’s learn about the error message “21889 – 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 Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
21889 – 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.
Reason for the Error
To be update soon…
Solution
To be update soon…