Message Details

Product Name SQL Server
Event ID 14120
Component SQL Server Database Engine
Symbolic Name
Message Text Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.


The distribution database stores metadata and history data for all types of replication and transactions for transactional replication. This error occurs if you attempt to drop a distribution database that is associated with one or more Publishers.

User Action

To drop a distribution database you must first drop the association between the Distributor and the Publisher. For more information, see sp_dropdistpublisher (Transact-SQL).

See Also

Errors and Events Reference (Replication)
Configure Distribution