Versions Compared

Old Version 1

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 CM components require .Net 2.0 or laterCompliance Manager 5.0 and later versions require .NET 4.0 components. Previous versions of SQL Compliance Manager require at least .NET 3.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 CM does not support the Itanium processor architecture. Versions up to and including SQL CM 3.5 continue to operate with Itanium, but no Itanium support is available. SQL CM 3.7 and later support SQL Server 2012 SP1.

SQL Compliance Manager Windows cluster support

You can install SQL CM 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.

...

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
2014
2022Windows Server
2008
2012, Windows Server 2012
MS SQL Server 2012 SP1Windows Server 2008 SP2MS SQL Server 2008 R2 Standard and Enterprise EditionsWindows Server 2008 R2
R2, Windows Server 2016, Windows Server 2019, Windows Server
2008
2022
MS
SQL Server
2008 Standard and Enterprise Editions
2019Windows Server
2008
2012, Windows Server 2012 R2, Windows Server
2003
2016,
or
Windows
2000
Server
SP4 or later
2019
MS
SQL Server
2005 Standard and Enterprise EditionsWindows Server 2003 or Windows 2000 Server SP4 or laterMS SQL Server 2000 Standard Edition SP3 or later *Windows Server 2003MS SQL Server 2000 Standard Edition SP2 or later *Windows 2000 Server SP4 or laterMS SQL Server 2000 Enterprise Edition *Windows 2000 Server SP4 or later

* SQL Compliance Manager does not support Before-After data auditing on SQL Server 2000 instances. This feature is available only for instances using SQL Server 2005 and above.

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 CM configuration and audit data.

2017Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

SQL Server 2016

Windows Server 2012, Windows Server 2012 R2, Windows Server 2016
SQL Server 2014Windows Server 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
Server 2003 SP2
  • 11
  • Windows
2000 SP4
  • 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
  • MS SQL Server 2012 SP1
  • MS SQL Server 2008 R2 Standard and Enterprise Editions
  • MS SQL Server 2008 Standard and Enterprise Editions
    • MS SQL Server 2005 Standard
    • 2022
    • SQL Server 2019
    • SQL Server 2017
    • SQL Server 2016
    • SQL Server 2014
    • SQL Server 2012 SP1
    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
    2000 SP4
    • 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.6 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 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
    Server 2003 SP2
    • 11
    • Windows
    2000 SP4
    • 10
    • Windows
    XP SP3
    • 8.1
    • Windows
    Vista SP2+
    • 8
    • Windows 7 SP1+
  • Windows 8
    • DocumentationInternet Explorer 7.0 or later

     

    SQL Compliance Manager audits all activity on your server. Learn more > >

    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

    		-
    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

    ...