MSSQLSERVER_21898
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 |
21898 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
SQLErrorNum21898 |
Message Text |
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'. |
Explanation
sp_validate_redirected_publisher queries msdb.dbo.MSdistpublishers at the local distributor to verify that the distribution database used by the new publisher is the same as the distribution database used by the original publisher. This error is returned when these databases are different, making the publisher an unsuitable host for the publisher database.
User Action
Execute stored procedure sp_changedistpublisher to change the distribution database for the new publisher to that used by the original publisher.
Note
Running sp_changedistpublisher will address the problem if the wrong distribution database was entered when sp_adddistpublisher was run at the distributor for the publisher. However, if the remote publisher has existing publications from another publishing database that make use of the identified distribution database, this change is not appropriate. Replication using the named distribution database needs to be systematically removed and then reestablished using the original publisher’s distribution database in order for the new publisher to function as a suitable host.