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.