Post reply

The remote procedure call failed and did not execute

  • January 27, 2006 at 2:06 am

    #92867

    Hi All,

     

    We have setup a snapshot replication between two servers.

    The primary server is itself distributor, publisher. And it push subscription to the subscriber. Initial snapshot sucessfully generated and applied to subscriber. We scheduled the distributor to deliver the snapshot to the subscriber once in a day. When the distributor tries to deliver the snapshot to subscriber it recursively trying to deliver it to subscriber continously.

    But the job does not shown any error like.  its status set to "executing step2".

    (Step 2 only delivers the snapshot to subscriber).

    And when i see the job history, it displays a message that "The remote procedure call failed and did not execute".

    SQL Agent,MSDTC,RPC services are running successfully.

    Can anybody tell me how to cover come this issue and complete the distributor to deliver the snapshot to subscriber sucessfully.

    Your help is much appreciated.

     

     

  • January 28, 2006 at 8:58 pm

    #617636

    Also check at the replication Monitor for more information and not just in the job history. May be you shoud reinitialize the entire publication and run the snapshot agent again. Check that the folder where the snapshot is saved is shared and has the proper permissions.

    Also, check that the distribution agent has at least db_owner permission at the subscriber database in the subscriber. The account that runs the distribution agent is the account that start the SQLServerAgent service at the publisher. This domain account must have permission at the subscriber.

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

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