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 member of the sysadmin fixed server role must add the user to the distribution database and assign that user to the replmonitor role.

To allow 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.