If you are implementing a minimal permissions setup, the following permissions are required on the SQL server:
The executing user account must be in the following groups on the SQL server:
- db_datareader
- db_datawriter
Users must have execute rights to all of the following procedures:
- usp_GetSummaryReportBody
- usp_GetSessionErrors
- usp_GetReportsList
- usp_GetReportsHeader
- usp_GetReportBody
- usp_GetReplicationHistory
- usp_GetOptionalObjects
- usp_GetOptionalAttributes
- usp_GetObjectChildren
- usp_GetObjectAttributes
- usp_GetAllObjects
- usp_GetAllChildObjects
- usp_GetAllAttributes
Procedures are located within Database_Name > Programmability > Stored Procedures, if using SQL Server Management Studio.