...
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.
...
SQL Compliance Manager supports auditing the following Microsoft SQL Server versions.
| SQL Server Version | Operating System |
|---|
MS Standard and Enterprise Editions | Windows Server 2008, Windows Server 2012, Windows Server 2012 R2 |
MS Standard and Enterprise Editions | Windows Server 2008, Windows Server 2012 |
MS SQL Server Standard and Enterprise EditionsMS Standard and Enterprise Editions | Windows Server 2008 R2, Windows Server 2008 |
MS Standard and Enterprise Editions | Windows Server 2008, Windows Server 2003 |
MS Standard and Enterprise EditionsCollection 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.
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. |
Server 2012 R2| Software Type | Requirement |
|---|
| Operating System | The Collection Server requires one of the following operating systems: |
Windows - Windows Server 2012
- Windows Server 2008 R2
- Windows Server 2008 SP1
- Windows
|
Server 2003 SP2Windows XP SP3Windows - Vista SP2+
- Windows 7 SP1+
- Windows 8+
- Windows 10
|
| Microsoft SQL Server | The Collection Server requires one of the following versions of Microsoft SQL Server: |
MS Standard and Enterprise EditionsMS Standard and Enterprise EditionsMS SQL Server Standard and Enterprise EditionsMS MS Standard and Enterprise Editions Standard and Enterprise EditionsMS SQL Server 2005 Standard and Enterprise Editions 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:- Windows Server 2012
- Windows Server 2008 R2
- Windows Server 2008 SP1
|
Windows Server 2003 SP2Windows XP SP3- Windows Vista SP2+
- Windows 7 SP1+
- Windows 8+
- Windows 10
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.0 requires you to upgrade the SQL Compliance Manager agents to version 5.0. |
Ensure the computer where the agent resides meets or exceeds the following software requirements.
2012 R2| Software Type | Requirement |
|---|
| Operating System | The agent requires one of the following operating systems: |
Windows Server - Windows Server 2012
- Windows Server 2008 R2
- Windows Server 2008 SP1
- Windows
|
Server 2003 SP2 XP SP3Windows Vista SP2 7 SP1+Windows 8Documentation Web Console
Supported web browsers for the IDERA SQL Compliance Manager Web console include:
...
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |
...
- 9.x+
- Microsoft Edge
- Google Chrome
- Mozilla Firefox
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal