How to configure replication? - This database is not enabled for publication.

Question

Hi,

I'm trying to configure repication on SQL Server 2005. I can done it using wizard. But when I'm trying to run generated scripts by this wizard the error message appears:

Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 159 This database is not enabled for publication. Msg 18757, Level 16, State 1, Procedure sp_MSrepl_addpublication_snapshot, Line 66 Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication. Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addarticle, Line 168 This database is not enabled for publication. Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 25 Supply either @job_id or @job_name to identify the job.

It's a bit strange, because when I'm running this query on database where I clicked and then removed publication, everyting is going well. The problem is when I'm using my query on new database. What is more I'm using sp_replicationdboption stored procedure. When I'm tryin to run it, it says:

The replication option 'publish' of database 'ReplicationTest00' has already been set to true.

Please help me resolve this issue.

Answer 1

I assume you have configured the Distributor for your Replication topology?

My advice with regards to Replication, do NOT execute your steps via the Wizard.

By all means, use the wizard to create your configuration options but rather than execute at then end, script out the steps. This way you have a full record of your configuration in T-SQL form and you manually make amendments/tweaks to the code presented.

Answer 2

Ok I found solution for this issue. I was tring to run snapshor replication script in context of whole sql server which was producing above error message.

When I was running my script in conctext of database which is used for replication as distributor it works perfectly. :)