How to add, modify, or disable a Subscriber (Enterprise Manager)

How to add, modify, or disable a Subscriber (Enterprise Manager)

To enable or disable a Subscriber

1. In SQL Server Enterprise Manager, expand a server group, expand the Distributor, right-click the Replication folder, and then click Configure Publishing, Subscribers, and Distribution.
   
   
2. Select what you want to do with the Subscriber.
   • To enable a Subscriber, click the Subscribers tab, and then if the Subscriber is listed, select the Subscriber.
     
     
   • To enable a Subscriber if it is not listed, on the Subscriber tab, click New Subscriber, click the type of Subscriber to register, and then enter the server, ODBC data source, or OLE DB data source, and connection information.
     
     
   • To disable a Subscriber, click the Subscribers tab, and then clear the box next to the Subscriber.

To modify a Subscriber

1. In SQL Server Enterprise Manager, expand a server group, expand the Distributor, right-click the Replication folder, and then click Configure Publishing, Subscribers, and Distribution.
   
   
2. Click the Subscribers tab, click the Subscriber to modify, and then click the properties button (...).
   
   
3. On the General tab, change the Subscriber description or the security mode.
   
   
4. Click the Schedules tab to modify default scheduling options.