The subscription to publication 'EBS' is invalid.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » The subscription to publication 'EBS' is...

The subscription to publication 'EBS' is invalid.

Rate Topic

Display Mode

Topic Options

Author

Message

ananda.murugesan

Posted Wednesday, January 07, 2009 11:46 PM

SSC Eights!

Group: General Forum Members
Last Login: Sunday, April 28, 2013 9:57 PM
Points: 817, Visits: 2,393

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?

Post #632138

Graeme100

Posted Wednesday, January 14, 2009 8:53 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:12 AM
Points: 1,209, Visits: 628

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

Post #636323

« Prev Topic | Next Topic »

Permissions