SQL Inventory Manager services requirements
You need to comply with the following requirements for installing SQL Inventory Manager collection services:
Type | Requirement | Suggestions |
---|---|---|
Microsoft Data Access Components | 2.8 or later | |
Microsoft. NET Framework version | 4.0 or later | If this software is not already installed on your computer, you must install it prior to the installation of SQL Inventory Manager. For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies. |
Operating System |
|
SQL Inventory Manager repository requirements
To install SQL Inventory Manager repositories you must have:
Type | Requirement |
---|---|
SQL Server Standard, Enterprise Edition, or Express Edition |
|
Monitored SQL Server instances requirements
All SQL Server instances that you wish to monitor should comply with the following requirements:
Type | Requirement |
---|---|
SQL Server Standard, Enterprise Edition, or Express Edition |
|
Browser requirements
Idera SQL Inventory Manager user interface can be accessed via web with the following browsers:
- Internet Explorer IE 9.x+
- Google Chrome
- Mozilla Firefox
Port requirements
Idera SQL Inventory Manager uses the following ports:
- Collection service port: 9275
- Web application service port: 9276
Required Accounts and Permissions
You need the following accounts and permissions:
Account | Action | Permissions required |
---|---|---|
Windows User Account | To install SQL Inventory Manager components | Windows Administrator permission on the Target computer |
To create and access the 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 |
Need more help? Search the Idera Customer Support Portal.