The subscription to publication 'EBS' is invalid.

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  January 7, 2009 at 11:46 pm

  #94445

  Hi,

  1. snapshots agent 33 atrical was generated succeeded

  2. After running push subscription was not succeeded

  First Server name - JGSRVR55

  Second server IP- 10.4.52.46

  I have checked for the following command, all are properly configured

  select * from sysservers from server A.

  SrvName - 10.4.52.46

  datasource- 10.4.52.46

  table and data has been copied to the Second server IP- 10.4.52.46, after copied the following error msg dispaly in server A - JGSRVR55

  Last command: {call sp_MSgetreplicainfo(?,?,?,?,?,?,?)}

  Error message: The subscription to publication 'MyPublicationName' is invalid.

  Error details: The subscription to publication 'MyPublicationName' is invalid.

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

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

  The remote server is not defined as a subscription server.

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

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

  How can I solve this issue?

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  January 14, 2009 at 8:53 am

  #926640

  Hi,

  One way to solve this is to be a little clearer with your post LOL....:)

  I'm not sure what you have done and at what point you are getting a failure.

  Can you give a little more information?

  Thanks

  Graeme