Page History
...
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 |
...
Scroll pdf ignore |
---|
SQL Business Intelligence Manager |
...
...