Hi everyone!
I have a problem with my replication. I've done merge replication, I have
one publisher and one subscriber. The connection between servers is via ADSL.
The merge replication does fine, when there is an active connection. But
when the connection (ADSL) drops, my merge agent stops with an error.
I changed the attempt times and interval in minutes under merge job to 100
times on 10 minutes. But nothing helps. When the connection drops, I
immediately get the error:
Could not connect to Subscriber.
Could not generate SSPI context.
Any ideas?
If you have an unreliable connection, there's no quick/simple fix. You could
schedule your merge agent to run once a minute, or hardcode the job steps to
continue on failure.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment