The replication option 'publish' of database <> has been set to false.

_{Wednesday, November 20, 2013 5:53 AM}

I have ran below command

sp_replicationdboption 'dbname','publish','true'

and received:

Server: Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Line 53
The Distributor has not been installed correctly. Could not enable database for publishing.
The replication option 'publish' of database <DBName>has been set to false.

Rahul

_{Wednesday, November 20, 2013 5:21 PM ✅Answered | 1 vote}

Hi Rahul,

You need to Configure Publishing and Distribution before you execute sp_replicationdboption.

Right-click the Replication folder, and then click Configure Distribution.

After publishing and distribution is configuring you can execute sp_replicationdboption.

Brandon Williams (blog | linkedin)