Page tree

The following sections provide the software requirements for each IDERA SQL Compliance Manager component. For more information, see Product components and architecture.

Support for MS SQL Server software includes case-sensitive servers and databases. Support for Windows operating systems includes English and international versions.  If an operating system service pack is not mentioned,  a service pack is not required for that version of the operating system.

All SQL Compliance Manager 5.0 and later versions require .NET 4.0 components. Previous versions of SQL Compliance Manager require at least .NET 3.5.

IDERA SQL Compliance Manager 5.5.x depends on certain Microsoft components that did not ship with SQL Server versions prior to SQL Server 2012 SP1. Before starting the installation process, please review some important installation steps.

Sensitive Column auditing is supported by SQL Compliance Manager Agent 3.5 or later. To use this feature, please ensure you upgrade your agent to at least version 3.5.

SQL Compliance Manager Windows cluster support

You can install SQL Compliance Manager on a Windows cluster 2008, 2012 and later. For more information, review the supported installation scenarios and Audit a virtual SQL Server instance.

Audited SQL Server

The audited SQL Server computer should meet or exceed the software requirements recommended by Microsoft to run and manage SQL Server databases. Note that .NET 4.0 or later must be installed on the audited server.

In a clustered environment with virtual SQL Servers, the audited SQL Server is the virtual SQL Server. However, each node (physical computer) in the cluster that hosts the virtual SQL Server must meet or exceed these requirements.

SQL Compliance Manager supports auditing the following Microsoft SQL Server versions.

SQL Server VersionOperating System
SQL Server 2019Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows 2019
SQL Server 2017Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

SQL Server 2016

Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016
SQL Server 2014Windows Server 2008, Windows Server 2012
SQL Server 2012 SP1Windows Server 2008 SP2
SQL Server 2008 R2Windows Server 2008 R2, Windows Server 2008
SQL Server 2008Windows Server 2008

Collection Server

The Collection Server stores SQL Compliance Manager configurations and audit data. Ensure your Collection Server resides on a version of SQL Server that is greater than or equal to the highest audited SQL Server version. For example, if the most current version of SQL Server that you are auditing is on SQL Server 2016 then your Collection Server instance could be SQL Server 2016 or 2017 but not 2012.

The Repository must reside on a version of SQL Server that is greater than or equal to the highest audited SQL Server version.

Software TypeRequirement
Operating SystemThe Collection Server requires one of the following operating systems:
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7 SP1+
Microsoft SQL ServerThe Collection Server requires one of the following versions of Microsoft SQL Server and supports all editions except SQL Server Express:
  • SQL Server 2019
  • SQL Server 2017
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012 SP1
  • SQL Server 2008 R2

Management Console

Ensure each console computer meets or exceeds the following software requirements. You can install the console on the Collection Server computer, or any client computer for remote access to your audit data.

Software TypeRequirement
Operating SystemThe Collection Server requires one of the following operating systems:
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7 SP1+

The Management Console computer also requires Microsoft Data Access Components (MDAC) 2.6 or later. If you plan to audit SQL Server 2005 instances, upgrade to MDAC 2.8 or later. SQL Server 2005 requires MDAC 2.8 to communicate with other applications.

DocumentationInternet Explorer 7.0 or later

Agent

SQL Compliance Manager 5.6 requires you to upgrade the SQL Compliance Manager agents to the same version.

Ensure the computer where the agent resides meets or exceeds the following software requirements.

Software TypeRequirement
Operating SystemThe agent requires one of the following operating systems:
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7 SP1+

Cloud

SQL Compliance Manager runs on various Cloud Virtual Machines running Microsoft Windows Server and Microsoft SQL Server.

SQL Compliance Manager can access mapped cloud drives but does not support cloud databases.

PaaS Support

Cloud relational database services are currently not supported for auditing or for deploying the software repository databases to, as SQL Compliance Manager requires an Agent Service or a Collection Management Service respectively, to be installed on the client and application/repository side.

Cloud Service Delivery ModelIaaSPaaS (DBaaS)
Amazon EC2

Windows Server

SQL Server

-
Microsoft Azure VM

Windows Server 

SQL Server

-

Google Cloud Platform

Windows Server

SQL Server

-


Web Console

Supported web browsers for the IDERA SQL Compliance Manager Web console include:

  • Internet Explorer 10.x+
  • Microsoft Edge
  • Google Chrome
  • Mozilla Firefox
  • Safari


It is important for you to review the IDERA Dashboard requirements before installing SQL Compliance Manager.



IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us | Legal