Server is not a subscriber

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Linton - 31 Aug 2006 03:36 GMT

Hi,

I have a SQL2005SP1 publushed database with 4 merge subscribers, everything
has been running just fine for month now. Yesterday two of the subscribers
stopped merging. This happened when I installed Reporting Services on the
publisher.
From Management Studio, if I right click on one of the problem subscriptions
and choose 'View Synchronisation Status' the dialog box that comes up gives a
Last status message of "The server 'ROSELLA' is not a Subscriber. (.Net
SqlClient Data Provider).
If I then click on the Start button I receive 'The agent could not be
started', 'Cannot find a merge agent job for the specified merge push
subscription. Changed database context to 'Workbench'. (Microsoft SQL
Server, Error: 21847)'
If I look at Agent Job Activity I see that there are jobs executing for all
the four subscribers.
How do I get replication happening again? My user will be very sad if they
lose the changes they have made.

thanks in advance

Reply to this Message

Hilary Cotter - 31 Aug 2006 13:35 GMT

It sounds like that agents are working fine, but Replication Monitor is
reporting an error. This sounds like a bug. Can you try to reapply SP1?

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 22 lines]
>
> thanks in advance

Reply to this Message