Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The subscription to publication 'EBS' is invalid. Expand / Collapse
Author
Message
Posted Wednesday, January 7, 2009 11:46 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:00 AM
Points: 1,054, Visits: 2,974
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
Posted Wednesday, January 14, 2009 8:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 1,221, Visits: 690
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 »

Add to briefcase

Permissions Expand / Collapse