Page History
...
| 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 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 Server Version | Operating System | |||||
|---|---|---|---|---|---|---|
| SQL Server 20192022 | Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019, Windows Server 2022 | |||||
| SQL Server 20172019 | Windows Server 20082012, Windows Server 2012 R2, Windows Server 2012 R22016, Windows Server 20162019 | |||||
| SQL Server 20162017 | Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016 | |||||
SQL Server | 20142016 | Windows Server | 20082012, Windows Server 2012 | SQL Server 2012 SP1 | R2, Windows Server | 2008 SP22016 |
| SQL Server 2008 R22014 | Windows Server 2008 R2, Windows Server 2008SQL Server 20082012 | |||||
| SQL Server 2012 SP1 | Windows Server 20082012 |
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.
...
| Software Type | Requirement |
|---|---|
| Operating System | The Collection Server requires one of the following operating systems:
|
| Microsoft SQL Server | The Collection Server requires one of the following versions of Microsoft SQL Server:
|
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 Type | Requirement |
|---|---|
| Operating System | The Collection Server requires one of the following operating systems:
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. |
| Documentation | Internet Explorer 7.0 or later |
...
| Software Type | Requirement |
|---|---|
| Operating System | The agent requires one of the following operating systems:
|
...
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.
...
| title | PaaS Support |
|---|
| Cloud |
|---|
...
| Service |
|---|
...
| 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
- Safari
| 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. |
...