Page History
...
SQL Compliance Manager supports auditing the following Microsoft SQL Server versions.
| SQL Server Version | Operating System |
|---|---|
| SQL Server 2017 | Windows 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 2014 | Windows Server 2008, Windows Server 2012 |
| SQL Server 2012 SP1 | Windows Server 2008 SP2 |
| SQL Server 2008 R2 | Windows Server 2008 R2, Windows Server 2008 |
| SQL Server 2008 | Windows Server 2008, Windows Server |
| 2005 | |
| SQL Server 2005 | Windows Server |
| 2005 |
Collection 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 Compliance Manager configuration and audit data.
...
| 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:
|
| Microsoft SQL Server | The Collection Server requires one of the following versions of Microsoft SQL Server and supports all editions except SQL Server Express:
|
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 |
Agent
| Info |
|---|
SQL Compliance Manager 5.5.x 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 Type | Requirement |
|---|---|
| Operating System | The agent requires one of the following operating systems:
|
Web Console
Supported web browsers for the IDERA SQL Compliance Manager Web console include:
...