How to enable a pull subscription to use remote agent activation

How to Install SQL Server 2000

How To

How to enable a pull subscription to use remote agent activation

To configure a pull subscription to use remote agent activation

  1. At the Subscriber, in SQL Server Enterprise Manager, expand the Replication folder, right-click the Subscriptions folder, and then click New Pull Subscription.

  2. Follow the steps in the wizard to create a new pull subscription.

  3. After the pull subscription is created, right-click on it, and then select Properties.

  4. Click the Synchronization tab, and then select Run the agent at the Distributor to offload agent processing from the Subscriber.

Important  After you specify where the agent should run when creating the subscription, synchronization may fail if you specified that the subscription should be automatically synchronized and you haven't configured DCOM for the remote agent activation.