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

Product Name

SQL Server

Event ID


Event Source




Symbolic Name


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.

Community Additions