Choose Publication

Replication Wizard Help

Replication Wizard Help

Choose Publication

When you expand a Publisher, SQL Server Enterprise Manager displays the publications that meet these requirements:

  • Your current login is included in the publication access list for that publication.

  • The current server is an enabled Subscriber at the Publisher or the publication allows anonymous subscriptions.

If the publication you want to subscribe to is not in the list, add the login used at the Subscriber to the publication access list for the publication. To add a login to the PAL:

  1. Click Cancel to exit the Create Pull Subscription Wizard.

  2. In Enterprise Manager, connect to the Publisher and right-click the publication that you want to subscribe to.

  3. Click Properties, and then on the Publication Access List tab, add the login used at the Subscriber.

If the current server is not enabled as a Subscriber at the Publisher, add the Subscriber. To add a Subscriber for this Publisher:

  1. Click Cancel to exit the Create Pull Subscription Wizard.

  2. In Enterprise Manager, connect to the Publisher and right-click the Replication folder and then click Configure Publishing, Subscribers, and Distribution.

  3. On the Subscribers tab, select the box to the left of the Subscriber name. If the Subscriber is not listed, click New Subscriber, than click the type of Subscriber to register, and enter the server and connection information.

If the publication does not allow anonymous subscriptions, change this property. To enable anonymous subscriptions:

  1. Click Cancel to exit the Create Pull Subscription Wizard.

  2. In Enterprise Manager, connect to the Publisher and right-click the publication that you want to allow anonymous subscriptions, and then click Properties.

  3. On the Subscription Options tab, select Allow anonymous subscriptions.

See Also

Anonymous Subscriptions

Pull Subscriptions

Subscribing to Publications