SQL Elements services requirements
You need to comply with the following requirements for installing SQL Elements collection services:
Type | Requirement | Suggestions |
---|---|---|
Microsoft Data Access Components (MDAC) | 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 Elements. For more information about the .NET Framework, see the NET Framework Versions and Dependencies article on MSDN. |
Operating System | Windows XP SP2+ Windows Server 2003 SP2 Windows Server 2008 SP2 Windows Vista SP2+ Windows 7 Windows 2008 R2 Windows 8 Windows 2012 |
SQL Elements repository requirements
To install SQL Elements 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 Elements user interface can be accessed via web with the following browsers:
- Internet Explorer IE 9.x+
- Google Chrome
- Mozilla Firefox
Port requirements
Idera SQL Elements 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 Elements components | Windows Administrator permission on the Target computer |
To create and access the SQL Elements 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 |