Required Accounts and Permissions
SQL Elements IDERA SQL Inventory Manager connects to registered SQL Server instances and their host computers to collect information. The collection service requires permissions to connect and gather information using SQL and WMI connection credentials.
Depending on the level of access and actions you want IDERA SQL Elements 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 |
Elements Inventory Manager components | Windows Administrator permission on the Target computer |
To create and access the IDERA SQL |
Elements Inventory Manager repository databases | - Create Database Rights on the target SQL Server Instance
- Read and write privileges on the IDERA SQL
|
Elements - 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 |
Linux | To install SQL Inventory Manager Repository on a Linux SQL Server | - The Linux server must be a domain member.
- A domain user with SQL permissions on the target SQL Linux.
|
To query Linux Server Info | - a Linux user.
- a domain user with Linux login rights.
|
Tip |
---|
IDERA |
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. |
Scroll Ignore |
---|
Newtabfooter |
---|
alias | IDERA |
---|
url | http://www.idera.com |
---|
| | Newtabfooter |
---|
alias | Products |
---|
url | https://www.idera.com/productssolutions/sqlserver |
---|
| | Newtabfooter |
---|
alias | Purchase |
---|
url | https://www.idera.com/buynow/onlinestore |
---|
| | Newtabfooter |
---|
alias | Support |
---|
url | https://idera.secure.force.com/ |
---|
| | Newtabfooter |
---|
alias | Community |
---|
url | http://community.idera.com |
---|
| | Newtabfooter |
---|
alias | Resources |
---|
url | http://www.idera.com/resourcecentral |
---|
| | Newtabfooter |
---|
alias | About Us |
---|
url | http://www.idera.com/about/aboutus |
---|
| | Newtabfooter |
---|
alias | Legal |
---|
url | https://www.idera.com/legal/termsofuse |
---|
|
|
Info |
---|
For more information on how to solve connection problems with WMI, click here.
|