Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQLSERVER_21898

SQL Server 2012

Product Name

SQL Server

Product Version

11.0

Product Build Number

11.00.0000.00

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'.

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.

Execute stored procedure sp_changedistpublisher to change the distribution database for the new publisher to that used by the original publisher.

Note 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.