Merge Rep. problem

• Larry C

  Default port

  Points: 1493

  More actions

  October 30, 2002 at 12:40 pm

  #58138

  I added a Push subscription to a merge publication. The subscription is being accessed via a VPN. When the subscription is being synchronized it appears that all is going fine, but after all of the articles have been sent to the subscriber the agent crashes. Below is the message I get:

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

  The subscription to publication 'Merge_Replication' is invalid.

  (Source: Merge Replication Provider (Agent); Error number: -2147201019)

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

  The remote server is not defined as a subscription server.

  (Source: 192.168.0.82 (Data source); Error number: 14010)

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

  All of the tables show up on the subscriber, so I don't know what the problem is.

  Oh, BTW, I also do a transactional push replication to this subscriber and it works fine.

  SQL2K, Win2K

  Thanks for any help.

• November 4, 2002 at 8:00 am

  This was removed by the editor as SPAM

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  November 4, 2002 at 3:16 pm

  #440286

  Saw a similar issue, might help:

  http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=eDJEyjZDCHA.2248%40tkmsftngp02&rnum=3&prev=/groups%3Fq%3DThe%2Bsubscription%2Bto%2Bpublication%2B%2Bis%2Binvalid.%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DeDJEyjZDCHA.2248%2540tkmsftngp02%26rnum%3D3

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter