February 26, 2015 at 11:06 pm
I am trying to configure replication using a script. I created the distribution database as well as the publisher. Now, I am running the stored procedure in one of the subscribers to create subscription. However, I keep getting the same error over and over again. The error reads:
msg 50000, Level 16, State 1, Procedure usp_create_AccountSubscriber, Line 43
Failed to execute SP usp_Create_AccountSubscriber: This database is not enabled for publication
what does it mean? n how can i solve it?
February 26, 2015 at 11:21 pm
Have you configured the distribution database and publisher properly, please check them.
With Thanks,
Satnam
February 26, 2015 at 11:25 pm
Yes, I am pretty sure I configured them correctly.
February 27, 2015 at 7:47 am
Check these on publisher's server:
select is_published
from sys.databases
where name = 'your_database_name'
go
select *
from distribution.dbo.MSpublications
where publisher_db = 'your_database_name'
go
February 27, 2015 at 8:09 am
It looks like you are trying to create subscription using your "Create publication custom script" and running it on Subscription database where it is failing which it will .
February 27, 2015 at 9:11 am
It does look like the publication is working. This is what I get:
is_published
1
February 27, 2015 at 9:34 am
It just shows that it's enabled for replication. Did you get any result from 2nd query?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply