Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

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 2.0.

Sensitive Column auditing is supported by SQLcompliance 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 2003, 2008, or 2012 cluster. 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
MS SQL Server 2016 Standard and Enterprise EditionsWindows Server 2008, Windows Server 2012, Windows Server 2012 R2
MS SQL Server 2014 Standard and Enterprise EditionsWindows Server 2008, Windows Server 2012
MS SQL Server 2012 SP1 Standard and Enterprise EditionsWindows Server 2008 SP2
MS SQL Server 2008 R2 Standard and Enterprise EditionsWindows Server 2008 R2, Windows Server 2008
MS SQL Server 2008 Standard and Enterprise EditionsWindows Server 2008, Windows Server 2003
MS SQL Server 2005 Standard and Enterprise EditionsWindows Server 2003

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.

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.

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 2012 R2
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows Server 2008 SP1
  • Windows Server 2003 SP2
  • Windows XP SP3
  • Windows Vista SP2+
  • Windows 7 SP1+
  • Windows 8
Microsoft SQL ServerThe Collection Server requires one of the following versions of Microsoft SQL Server:
  • MS SQL Server 2016 Standard and Enterprise Editions
  • MS SQL Server 2014 Standard and Enterprise Editions
  • MS SQL Server 2012 SP1 Standard and Enterprise Editions
  • MS SQL Server 2008 R2 Standard and Enterprise Editions
  • MS SQL Server 2008 Standard and Enterprise Editions
  • MS 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 TypeRequirement
Operating SystemThe Collection Server requires one of the following operating systems:
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows Server 2008 SP1
  • Windows Server 2003 SP2
  • Windows XP SP3
  • Windows Vista SP2+
  • Windows 7 SP1+
  • Windows 8

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.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.

Software TypeRequirement
Operating SystemThe agent requires one of the following operating systems:
  • Windows Server 2012 R2
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows Server 2008 SP1
  • Windows Server 2003 SP2
  • Windows XP SP3
  • Windows Vista SP2+
  • Windows 7 SP1+
  • Windows 8
DocumentationInternet Explorer 7.0 or later
SQL Compliance Manager audits all activity on your server. Learn more > >