Allow Non-Administrators to Use Replication Monitor

This topic describes how to allow non-administrators to use Replication Monitor in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL. Replication Monitor can be used by users who are members of the following roles:

The sysadmin fixed server role.

These users can monitor replication and have full control over changing replication properties such as agent schedules, agent profiles, and so on.

The replmonitor database role in the distribution database.

These users can monitor replication, but cannot change any replication properties.

At the Distributor on the distribution database, execute sp_helprolemember (Transact-SQL), specifying a value of replmonitor for the @rolename parameter. If the user is listed in MemberName in the result set, the user already belongs to this role.

If the user does not belong to the replmonitor role, execute sp_addrolemember (Transact-SQL) at the Distributor on the distribution database. Specify a value of replmonitor for @rolename and the name of the database user or the Microsoft Windows login being added for @membername.

To remove a user from the replmonitor fixed database role

To verify that the user belongs to the replmonitor role, execute sp_helprolemember (Transact-SQL) at the Distributor on the distribution database, and specify a value of replmonitor for @rolename. If the user is not listed in MemberName in the result set, the user does not currently belong to this role.

If the user does belong to the replmonitor role, execute sp_droprolemember (Transact-SQL) at the Distributor on the distribution database. Specify a value of replmonitor for @rolename and the name of the database user or the Windows login being removed for @membername.