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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy