The IDERA Dashboard and SQL BI Manager connect to registered SQL Server instances and their host computers to collect information. The collection service requires permission to connect and gather information using SQL and WMI connection credentials.
The IDERA Dashboard and SQL BI Manager requires the assignment of the following permissions for the accounts listed:
| Account | Action | Permissions required |
|---|---|---|
| Windows user account or Windows security group user account | To install IDERA Dashboard and SQL BI Manager components | Windows Administrator permission on the Target computer |
To create and access the Core and SQL BI Manager repository databases |
| |
SQL Server login account | For most SQL queries | VIEW SERVER STATE VIEW ANY DATABASE VIEW ANY DEFINITION |
| To monitor database information | ALTER ANY DATABASE server-level permission or CREATE DATABASE in the master database | |
| For DBCC CHECKDB | sysadmin server roles | |
| WMI account | To access remote WMI data | Additional rights on a group that has been given remote access |