Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

Enabling Replication Subscribers

To allow remote servers to receive data from your server, you must enable permissions for the remote servers using the SQL Enterprise Manager.

To enable subscribers, follow these steps:

1.

Select the server on which you want to add a publication.

2.

From the SQL Enterprise Manager menu, select Tools and then select Replication. A drop-down menu appears. Select the Configure Publishing, Subscribers, and Distribution option. The Publisher and Distributor Properties dialog box appears. Select the Subscribers tab, shown in Figure 27.13. Figure 27.13. The Publisher and Distributor Properties dialog box—Subscribers tab. To enable a server to subscribe, select the check box next to the server's name. To disable a ...