Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Choose Publication

SQL Server 2000

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.