Page History
...
| Account | Action | Permissions required |
|---|---|---|
| Windows User Account | To install IDERA SQL Inventory Manager components | Windows Administrator permission on the Target computer |
To create and access the IDERA SQL Inventory 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 |
| Tip | ||
|---|---|---|
| ||
IDERA suggests that you provide SQL connection credentials with "sysadmin" server roles if you want to be able to collect all information from your environment. |
| Info |
|---|
For more information on how to solve connection problems with WMI, see Troubleshooting WMI issues. |
| Excerpt |
|---|
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |