21898

Product

Name

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

at distributor ‘%s’ to

change the distribution database used by the publisher to ‘%s’.

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

to change the distribution database for the

new publisher to that used by the original publisher.

ﾉ

Expand table

７

Note

Running

will address the problem if the wrong distribution

database was entered when

was run at the distributor for the