SQL Elements services requirements  

You need to comply with the following requirements for installing SQL Elements collection services:

TypeRequirementSuggestions
Microsoft Data Access Components (MDAC)2.8 or later 
Microsoft. NET Framework version4.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.

Operative 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

  • SQL Server 2005 SP1+
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014

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

  • SQL Server 2005 SP1+
  • SQL Server 2008 SP1+
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014

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:

AccountActionPermissions 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

  • Create Database Rights on the target SQL Server Instance
  • Read and write privileges on 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

WMI accountTo access remote WMI dataadditional rights
  • No labels