I am having a number of problems with the merge replication is SQL2000 -
Win2000 Server. The subscribers are not connecting and replicating the
data as required. The NSLOOKUP statement finds the servers on the
network and I can ensure that there is connectivity between them.
I am consistently getting the error : The merge process could not
initialise the subscription, The process has been retried the specified
number of times (10) without succeeding.
I have since increased the 'retry attempts' to 9999 in the advanced tab
of the steps property for that particular subscription.
Does anyone have ANY IDEAS on what else I can do,
Would you recommend a looping process whereby on failure of step 3 it
will loopback and start again at step 1. I don't feel comfortable doing
this as there must be a problem if after 9999 retries step 3 still
fails, it could keep trying forever, I need to address another issue
PLEASE ANY HELP WOULD BE MUCH APPRECIATED,
THANKS IN ADVANCE
Johannesburg, South Africa
Posted via http://dbforums.com