Setting up distributor on subscriber | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Setting up distributor on subscriber

Hi All, Trying to set up replication for the first time and I am having no luck setting up the distributor on the subscriber. Is this even possible or does it have to be on the publisher? I am gettin this error: error 29928: the distributor has not been installed correctly. Could not enable database for publishing. The replication option ‘publish’ of database ‘DBA’ has been set to false Where can i check/troubleshoot this? Thanks in advance.
BOL says sp_replicationdboption should be used to enable or disable publishing in a database.

Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.