IDERA SQL Inventory Manager connects to registered SQL Server instances and their host computers to collect information.
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:
|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|
|Linux||To install SQL Inventory Manager Repository on a Linux SQL Server|
|To query Linux Server Info|
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.