Post reply

The snapshot could not be generated because the publication is inactive.

  • August 31, 2004 at 8:16 am

    #85238

    I am having trouble setting up a pull or push subscription.  Any time I try to set up a subscription it will recognize the server the publication and distribution is on, but it will not bring up the replicated database.  There are red x's on the replication monitor that gives this error:

    "The snapshot could not be generated because the publication is inactive."

    I cannot get the replication activated or get SQL to recognize there is an exisiting publication to create a subscription!

    Any help is appreciated!  Thanks!

    Jasmina

  • September 1, 2004 at 5:53 am

    #521329

    See this posting.  It probably has to do with the server names between the publisher and subscriber.

     

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=132613#bm132783

  • September 1, 2004 at 6:54 am

    #521338

    do this

     

    sp_changepublication 'PublicationName', 'status','active'

    --

    Hilary Cotter

    Looking for a book on SQL Server replication?

    http://www.nwsu.com/0974973602.html

  • September 3, 2004 at 12:47 pm

    #521716

    Did you get it working?

  • September 3, 2004 at 2:02 pm

    #521723

    I just tried it!  IT WORKED!!!  THANK YOU SOOOOO MUCH!!!!  But when I initiated the pull subscription and it started to update the publishing db I locked out all the users (oops )  THANK YOU SOOOOOOOOO MUCH for your help!!!!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply