merge replication

  • hi there

    i have some problem regarding merge replication. i am using sql server 2000 and service pack 4.0. Push type . it indicates error as "The process could not connect to subscriber (SUBSCRIBER SERVERNAME) the step was retired.

    everyone else experience this. please help me.

    yasin

  • Well, I haven't worked with merge replication per se, but I've seen this type of error in other replication scenarios.

    If I recall correctly, we need to make sure the account the SQL Agent service is running under on the publisher has proper (administrative) access on the target (subscriber) instance(s). 

    You may need to add that account manually to the "System Administrator" role on the subscriber instances.  Think replication uses the credentials of the SQL Agent account to authenticate.

    Buenos dias!

    - john

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply