How to: Allow Non-Administrators to Use Replication Monitor (SQL Server Management Studio)

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.

To allow non-administrators to use Replication Monitor, a login with ALTER ANY LOGIN permission (such as member of the sysadmin or securityadmin fixed server roles) must add the login as a user to the distribution database and assign that user to the replmonitor fixed database role. Additionally, the user must have access to the publication database and the msdb database on the Publisher.

To enable non-administrators to use Replication Monitor

  1. In Microsoft SQL Server Management Studio, connect to the Distributor, and then expand the server node.

  2. Expand Databases, expand System Databases, and then expand the distribution database (named distribution by default).

  3. Expand Security, right-click Users, and then click New User.

  4. Enter a user name and login for the user.

  5. Select a default schema of replmonitor.

  6. Select the replmonitor check box in the Database role membership grid.

  7. Click OK.