Skip to content

add-and-remove-publishers-from-replication-monitor.md

Latest commit

 

History

History
108 lines (64 loc) · 8.37 KB

add-and-remove-publishers-from-replication-monitor.md

File metadata and controls

108 lines (64 loc) · 8.37 KB
title Add & remove Publishers from Replication Monitor (SSMS)
description Learn to add and remove Publishers from Replication Monitor in SQL Server Management Studio (SSMS).
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology replication
ms.topic conceptual
helpviewer_keywords
Replication Monitor, adding and removing Publishers
ms.assetid fa36c4b4-bfa5-494e-92e3-07a02d7332c3
author MashaMSFT
ms.author mathoma
monikerRange =azuresqldb-mi-current||>=sql-server-2016||=sqlallproducts-allversions

Add and Remove Publishers from Replication Monitor

[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md] The server from which you launch Replication Monitor is automatically added to the monitor if it is a Publisher. Additional Publishers can be added through the Add Publisher dialog box. After adding a Publisher, it is displayed in a group in the left pane of the monitor. The My Publishers group is included by default, but you can create new groups to manage one or more replication topologies. For information about starting Replication Monitor, see Start the Replication Monitor.

To add a SQL Server Publisher

  1. Right-click the Replication Monitor node or a Publisher group node in the left pane, and then click Add Publisher.

  2. In the Add Publisher dialog box, click Add, and then click Add SQL Server Publisher.

  3. In the Connect to Server dialog box, enter the name of the Publisher, and then select the authentication type. If you select SQL Server Authentication, enter a login and password. The credentials you specify are saved by Replication Monitor to use when connecting to this server in the future. The Windows account or SQL Server login specified must be a member of the sysadmin fixed server role or a member of the replmonitor fixed database role in the distribution database.

  4. Click Connect. If the Publisher uses a remote Distributor, you will be prompted to connect to the Distributor in the Connect to Server dialog box. The credentials you specify are saved by Replication Monitor to use when connecting to this server in the future. The Windows account or SQL Server login specified must be a member of the sysadmin fixed server role or a member of the replmonitor fixed database role in the distribution database.

  5. The name of the Publisher and Distributor are displayed in the Start monitoring the following Publisher(s) grid.

  6. To specify refresh and connection options for the Publisher, select the Publisher in the grid, and modify options as necessary. For more information about refresh options, see Caching, Refresh, and Replication Monitor Performance.

  7. Select the group under which the Publisher should be displayed in Replication Monitor. To create a new group, click New Group, and then enter a group name; select the group in the Show this Publisher(s) in the following group list.

  8. [!INCLUDEclickOK]

To add an Oracle Publisher

  1. Right-click the Replication Monitor node or a Publisher group node in the left pane, and then click Add Publisher.

  2. In the Add Publisher dialog box, click Add, and then click Add Oracle Publisher.

  3. In the Connect to Server dialog box, enter the name of the [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Distributor associated with the Oracle Publisher, and then select the authentication type. If you select SQL Server Authentication, enter a login and password. The credentials you specify are saved by Replication Monitor to use when connecting to this server in the future. The Windows account or SQL Server login specified must be a member of the sysadmin fixed server role or a member of the replmonitor fixed database role in the distribution database.

  4. Click Connect.

  5. The name of the Publisher and Distributor are displayed in the Start monitoring the following Publisher(s) grid.

  6. To specify refresh and connection options for the Publisher, select the Publisher in the grid, and modify options as necessary. For more information about refresh options, see Caching, Refresh, and Replication Monitor Performance.

  7. Select the group under which the Publisher should be displayed in Replication Monitor. To create a new group, click New Group, and then enter a group name; select the group in the Show this Publisher(s) in the following group list.

  8. [!INCLUDEclickOK]

To add one or more Publishers that use the same Distributor

  1. Right-click the Replication Monitor node or a Publisher group node in the left pane, and then click Add Publisher.

  2. In the Add Publisher dialog box, click Add, and then click Specify a Distributor and Add Its Publishers.

  3. In the Connect to Server dialog box, enter the name of the Distributor, and then select the authentication type. If you select SQL Server Authentication, enter a login and password. The credentials you specify are saved by Replication Monitor to use when connecting to this server in the future. The Windows account or SQL Server login specified must be a member of the sysadmin fixed server role or a member of the replmonitor fixed database role in the distribution database.

  4. Click Connect.

  5. The name of the Distributor and each Publisher are displayed in the Start monitoring the following Publisher(s) grid. If a Publisher has already been added to Replication Monitor, it does not appear in the grid.

  6. To specify refresh and connection options for the Publisher, select the Publisher in the grid, and modify options as necessary. For more information about refresh options, see Caching, Refresh, and Replication Monitor Performance.

  7. Select the group under which Publishers should be displayed in Replication Monitor. To create a new group, click New Group, and then enter a group name; select the group in the Show this Publisher(s) in the following group list.

  8. [!INCLUDEclickOK]

To modify settings for the Publisher and Publisher Groups

  1. Right-click a Publisher in the left pane, and then click Publisher Settings.

  2. Make any changes in the Publisher Settings dialog box:

    • To change the credentials that Replication Monitor uses to connect to a server, click Publisher Connection or Distributor Connection, and then enter credentials in the Connect to Server dialog box.

    • To move a Publisher from one group to another, select the Publisher in the Start monitoring the following Publisher(s) grid, and then select the new group in the Show this Publisher(s) in the following group list.

  3. [!INCLUDEclickOK]

To remove a Publisher from Replication Monitor

  1. Right-click a Publisher in the left pane.

  2. Click Remove.

To add a Publisher group to Replication Monitor

  1. Publisher groups can be created only when adding a Publisher or modifying settings for a Publisher. See the how to procedures on adding a Publisher for more information.

To remove a Publisher group from Replication Monitor

  1. Move all Publishers to a different group or remove them from Replication Monitor. For more information, see previous procedures in this topic.

  2. Right-click the Publisher group, and then click Remove.

See Also

Configure Distribution
Monitoring Replication