Mirror Replication Agent for Microsoft SQL Server must create database objects to assist with replication tasks in the primary database.
The user ID that the Mirror Replication Agent instance uses to log in to the Microsoft SQL Server must have access to the primary database with the following permissions granted:
create table – required to create tables in the primary database.
create trigger – required to create DDL triggers in the primary database.
create procedure – required to create procedures in the primary database.
db_owner role – required to allow Mirror Replication Agent to execute sp_repltrans and sp_repldone in the primary database. This role is also required for primary database initialization.
sysadmin role – required for Microsoft SQL Server data server initialization and deinitialization (using pdb_init, ra_init, and ra_deinit, respectively).
