go grant execute on msdb.dbo.sp_help_notification to [yourdomain\SSReplMPLowPriv] go select on msdb.dbo.sysalerts to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysoperators to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysnotifications to [yourdomain\SSReplMPLowPriv] go select on msdb.dbo.sysjobschedules to [yourdomain\SSReplMPLowPriv] go select on msdb.dbo.sysschedules to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysjobhistory to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysjobservers to [yourdomain\SSReplMPLowPriv] go execute on msdb.dbo.agent_datetime to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysjobs to [yourdomain\SSReplMPLowPriv] go Note The Distributor may have more than one Distribution database (one for specific Publisher). To configure permissions on the System Center Operations Manager Management Server Local Administrator permissions to SSREPLSDK account.
go grant execute on msdb.dbo.sp_help_notification to [yourdomain\SSReplMPLowPriv] go select on msdb.dbo.sysalerts to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysoperators to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysnotifications to [yourdomain\SSReplMPLowPriv] go select on msdb.dbo.sysjobschedules to [yourdomain\SSReplMPLowPriv] go select on msdb.dbo.sysschedules to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysjobhistory to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysjobservers to [yourdomain\SSReplMPLowPriv] go execute on msdb.dbo.agent_datetime to [yourdomain\SSReplMPLowPriv] go grant select on msdb.dbo.sysjobs to [yourdomain\SSReplMPLowPriv] go Note The Distributor may have more than one Distribution database (one for specific Publisher). To configure permissions on the System Center Operations Manager Management Server Local Administrator permissions to SSREPLSDK account.
SQLServer2012ReplicationMPGuide.docx