The following sections provide the software requirements for each IDERA SQL Compliance Manager component. For more information, see 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 a service pack is not required for that version of the operating system.
All SQL CM Compliance Manager 5.0 and later versions require .NET 4.0 components. Previous versions of SQL CM Compliance Manager require at least .NET 2.03.5.
Note |
---|
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. |
Info |
---|
Sensitive Column auditing is supported by SQLcompliance SQL Compliance Manager Agent 3.5 or later. To use this feature, please ensure you upgrade your agent to at least version 3.5. |
infoThis version of SQL CM does not support the Itanium processor architecture. Versions up to and including SQL CM 3.5 continue to operate with Itanium, but no Itanium support is available. |
SQL
...
SQL Compliance Manager Windows cluster support
You can install SQL CM SQL Compliance Manager on a Windows 2003, cluster 2008, or 2012 clusterand later. For more information, review the the supported installation scenarios and and Audit a virtual SQL Server instance.
...
SQL Compliance Manager supports auditing the following Microsoft SQL Server versions.
SQL Server Version | Operating System |
---|
MS 2014 20082012, Windows Server 2012 |
MS SQL Server 2012 SP1 | Windows Server 2008 SP2 |
MS SQL Server 2008 R2 Standard and Enterprise Editions | R2, Windows Server 2016, Windows Server 2019, Windows Server 2022 |
SQL Server 2019 | Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019 |
SQL Server 2017 | Windows Server 2012, Windows Server 2012 |
Windows Server 2008 2008MS 2008 Standard and Enterprise Editions2016 | Windows Server 2012, Windows Server |
2008 2003MS 2005 Standard and Enterprise Editions 2003Collection Server
Ensure each Collection Server computer meets or exceeds the following software requirements. The Collection Server hosts the Collection Service and the Repository databases, which store SQL CM configuration and audit data.
2012 |
SQL Server 2012 SP1 | Windows Server 2012 |
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 If you plan to audit instances running SQL Server 2005 or later, install the Collection Server on a computer hosting the highest version of SQL Server running in your environment. For example, to accept event data from audited instances running SQL Server 2012 SP1, the Repository databases must reside on a SQL Server 2012 SP1 instance.
Note |
---|
The Repository must reside on a version of SQL Server that is greater than or equal to the highest audited SQL Server version. |
Software Type | Requirement |
---|
Operating System | The Collection Server requires one of the following operating systems: |
2012 R2 2012 2008 R2 2008 SP1 Server 2003 SP2 XP SP3 Vista SP2+Windows 8 |
Microsoft SQL Server | The Collection Server requires one of the following versions of Microsoft SQL Server: |
MS 2014MS SQL Server 2012 SP1MS SQL Server 2008 R2 Standard and Enterprise EditionsMS SQL Server 2008 Standard and Enterprise EditionsMS SQL Server 2005 Standard - 2022
- SQL Server 2019
- SQL Server 2017
- SQL Server 2016
- SQL Server 2014
- SQL Server 2012 SP1
|
and Enterprise EditionsManagement 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 Type | Requirement |
---|
Operating System | The Collection Server requires one of the following operating systems: |
2012 2008 R2 2008 SP1 2003 SP2- 2012
- Windows 11
- Windows 10
- Windows
|
XP SP3 Vista SP2+Windows 8The 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. |
Documentation | Internet Explorer 7.0 or later |
Agent
Info |
---|
SQL Compliance Manager 5.0 6 requires you to upgrade the SQL CM Compliance Manager agents to the same version 5.0. |
Ensure the computer where the agent resides meets or exceeds the following software requirements.
Software Type | Requirement |
---|
Operating System | The agent requires one of the following operating systems: |
2012 R2 2012 2008 R2 2008 SP1 Server 2003 SP2 XP SP3 Vista SP2+Cloud
...
SQL Compliance Manager runs on various Cloud Virtual Machines running Microsoft Windows Server and Microsoft SQL Server.
Cloud Service Delivery Model | IaaS | PaaS (DBaaS) |
---|
Amazon EC2 | Windows Server SQL Server | - |
Microsoft Azure VM | Windows Server SQL Server | - |
Google Cloud Platform | Windows Server SQL Server | - |
Amazon RDS | - | SQL Server |
Amazon EC2 SQL Server | - | SQL Server |
Info |
---|
Amazon RDS support is limited to use it as an audited instance. |
Web Console
Supported web browsers for the IDERA SQL Compliance Manager Web console include:
- Internet Explorer 10.x+
- Microsoft Edge
- Google Chrome
- Mozilla Firefox
Note |
---|
It is important for you to review the IDERA Dashboard requirements before installing SQL Compliance Manager. |
Note |
---|
SQL Compliance Manager is ONLY compatible with IDERA Dashboard version 4.6 and with limited support. |
SQL Compliance Manager audits all activity on your server. Learn more > >
...