Page History
...
Depending on the level of access and actions you want IDERA SQL Inventory Manager to perform on your environment, you should check you have the following permissions in each account:
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 |
...
Info |
---|
For more information on how to solve connection problems with WMI, click here.see Troubleshooting WMI issues. |
Excerpt |
---|
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
...