creating a new subscription in 2005 but getting following error Exception Message: The snapshot could not be generated because the publisher is inactive.

• MAK-1128556

  SSCarpal Tunnel

  Points: 4594

  More actions

  December 3, 2009 at 11:16 pm

  #137403

  I try to create new subscrition, and when I try to view snapshort agent status I am getting following error in replication moniter, I can't start

  Exception Message: The snapshot could not be generated because the publisher is inactive.

  2009-12-04 06:01:39.53 Message Code: 54057

  2009-12-04 06:01:39.53

• sharon-644450

  Default port

  Points: 1442

  More actions

  January 5, 2012 at 4:24 am

  #1428891

  To fix the problem, you can call the following stored procedure:

  sp_changedistpublisher 'YOUR-PUBLISHER-NAME', 'active', 'true'