Versions Compared

Old Version 10

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Rodrigo Rivero

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Compliance Manager 5.0 and later versions require .NET 4.0 components. Previous versions of SQL 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.

Info

This version of SQL Compliance Manager does not support the Itanium processor architecture. Versions up to and including SQL Compliance Manager 3.5 continue to operate with Itanium, but no Itanium support is available. SQL Compliance Manager 3.7 and later support SQL Server 2012 SP1.

SQL Compliance Manager Windows cluster support

You can install 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 VersionOperating System
MS
SQL Server
2014
2022Windows Server
2008
2012, Windows Server 2012
MS SQL Server 2012 SP1Windows Server 2008 SP2MS SQL Server 2008 R2 Standard and Enterprise Editions
R2, Windows Server 2016, Windows Server 2019, Windows Server 2022
SQL Server 2019Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019
SQL Server 2017Windows Server 2012, Windows Server 2012
Windows Server 2008
R2, Windows Server
2008
2016
MS

SQL Server

2008 Standard and Enterprise Editions

2016

Windows Server
2008
2012, Windows Server 2012 R2, Windows Server
2003
2016
MS
SQL Server
2005 Standard and Enterprise Editions
2014Windows 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.

2012
SQL Server 2012 SP1Windows 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 TypeRequirement
Operating SystemThe Collection Server requires one of the following operating systems:
  • Windows Server
2012 R2
  • 2022
  • Windows Server
2012
  • 2019
  • Windows Server
2008 R2
  • 2016
  • Windows Server
2008 SP1
  • 2012
  • Windows 11
  • Windows
Server 2003 SP2
  • 10
  • Windows
XP SP3
  • 8.1
  • Windows
Vista SP2+
  • 8
  • Windows 7 SP1+
  • Windows 8
    • Microsoft SQL ServerThe Collection Server requires one of the following versions of Microsoft SQL Server:
      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
      • 2022
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012 SP1
      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
      • 2022
      • Windows Server
      2008 R2
      • 2019
      • Windows Server
      2008 SP1
      • 2016
      • Windows Server
      2003 SP2
      • 2012
      • Windows 11
      • Windows 10
      • Windows
      XP SP3
      • 8.1
      • Windows
      Vista SP2+
      • 8
      • 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

      Info

      SQL Compliance Manager 5.0 6 requires you to upgrade the SQL Compliance Manager agents to the same 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
      • 2022
      • Windows Server
      2012
      • 2019
      • Windows Server
      2008 R2
      • 2016
      • Windows Server
      2008 SP1
      • 2012
      • Windows 11
      • Windows
      Server 2003 SP2
      • 10
      • Windows
      XP SP3
      • 8.1
      • Windows
      Vista SP2+
      • 8
      • Windows 7 SP1+

      Cloud

      SQL Compliance Manager runs on various Cloud Virtual Machines running Microsoft Windows Server and Microsoft SQL Server.


      Cloud Service Delivery ModelIaaSPaaS (DBaaS)
      Amazon EC2

      Windows Server

      SQL Server

      		-
    • Windows 8
      • DocumentationInternet Explorer 7.0 or later
      Excerpt
      SQL Compliance Manager audits all activity on your server. Learn more > >

      ...

      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.

      Scroll pdf ignore
      Newtabfooter
      aliasIDERA
      urlhttp://www.idera.com
       | 
      Newtabfooter
      aliasProducts
      urlhttps://www.idera.com/productssolutions/sqlserver
             | 
      Newtabfooter
      aliasPurchase
      urlhttps://www.idera.com/buynow/onlinestore
       | 
      Newtabfooter
      aliasSupport
      urlhttps://idera.secure.force.com/
       | 
      Newtabfooter
      aliasCommunity
      urlhttp://community.idera.com
             |              
      Newtabfooter
      aliasResources
      urlhttp://www.idera.com/resourcecentral
       | 
      Newtabfooter
      aliasAbout Us
      urlhttp://www.idera.com/about/aboutus
             | 
      Newtabfooter
      aliasLegal
      urlhttps://www.idera.com/legal/termsofuse

      ...