In this blog post, let’s learn about the error message “21898 – The publisher ‘%s’ uses distribution database ‘%s’ and not ‘%s’ which is required in order to host the publishing database ‘%s’. Run sp_changedistpublisher at distributor ‘%s’ to change the distribution database used by the publisher to ‘%s’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
21898 – The publisher ‘%s’ uses distribution database ‘%s’ and not ‘%s’ which is required in order to host the publishing database ‘%s’. Run sp_changedistpublisher at distributor ‘%s’ to change the distribution database used by the publisher to ‘%s’.
Reason for the Error
To be update soon…
Solution
To be update soon…