An Overview of the Report Manager Security The Report Manager needs to be able to access both the Enterprise Reporter server, the Enterprise Reporter database, and the Access Explorer database, as shown in the figure below. The logged in credentials need the following permissions in order to successfully run and create reports and use Access Explorer: • To log in to the Report Manager, the logged in user must be in the Reporter_Reporting_Admins or Reporter_Reporting_Operators security group. For more information, see the Quest Enterprise Reporter Configuration Manager User Guide. • To run reports in Access Explorer, the logged in user must be in the Reporter_Exploring_Operators group. • To access the server, the logged in user must be a domain account. • The account being used to access the database must have read access to the database to read reports, and write access to the database to publish reports. This account is chosen when you log in to the Report Manager. If you are using Windows authentication, the account should already have these permissions because they must be in a security group in order to log in to the console. SQL accounts must be permissioned manually. SQL Authentication is only supported for the Enterprise Reporter database, not the Access Explorer database.
