How to configure publishing and distribution (Enterprise Manager)

How to Install SQL Server 2000

How To

How to configure publishing and distribution (Enterprise Manager)

  1. In SQL Server Enterprise Manager, expand a SQL Server group, expand a server, right-click the Replication folder, and then click Configure Publishing, Subscribers, and Distribution.

  2. Follow the wizard pages to select a Distributor, create the distribution database, and then on the Customize the Configuration page, either accept Publisher and Subscriber defaults, or select Yes, let me set the distribution database properties, enable Publishers or set the publishing settings.

    This allows you to set distribution database properties, enable Publishers, enable publication databases, and enable Subscribers using the wizard. You can also configure these properties later in the Publisher and Distributor properties.