Transacation Replication Push subscription error message

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  November 25, 2019 at 9:17 pm

  #3700769

  I have transactional replication setup with push subscriptions.

  When I expand publication and right click subscriber to "view synchronization status" it is giving this error message below, but replication monitor does any error and I am able to replicate data.

  An error occurred while attempting to access the subscription. (View Synchronization Status)

  ------------------------------

  To synchronize, you must first create an agent job for this subscription. (View Synchronization Status)

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  November 26, 2019 at 3:49 pm

  #3701107

  so either sp_addsubsciption hasn't run (I seriously doubt that)

  This sounds like a permission issue, but i'm struggling with your English a little

  first steps, can you put a tracer token through? - this makes us sure that the main stuff is working

  MVDBA