How to enable SQL Server database for publication
SQL Server Replication
·Jun 14, 2022·
1 min read
I have configured the distributor and then trying to create a publication on the publication server using
sp_addpublication stored procedures with respective parameters. I have got the below error message.
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 178 [Batch Start Line 3] This database is not enabled for publication.
- Right click on the replication folder in object explorer and open publisher properties.
- Select "Publication Databases" and then enable transactional or/and merge replication according to your requirement. Then click OK.
use your_publication_db_name; exec sp_replicationdboption @dbname = 'your_publication_db_name', @optname = 'publish', @value = 'true' go
- How to fix "This database is not enabled for publication" issue when the replication option is already enabled in SQL Server?
Let me know in comments if this solves your issue or not.