Versions Compared

Key

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

...

2014 2008 SP2
SQL Server VersionOperating System
SQL Server 20192022Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows 2019, Windows Server 2022, Windows 11
SQL Server 20172019Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows 2019
SQL Server 20162017Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

SQL Server

2016

Windows Server 2008, Windows Server 2012SQL Server 2012 SP1, Windows Server 2012 R2, Windows Server 2016
SQL Server 2008 R22014Windows Server 2008 R2, Windows Server 2008SQL Server 20082012
SQL Server 2012 SP1Windows Server 2008 SP2

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.

...

Software TypeRequirement
Operating SystemThe Collection Server requires one of the following operating systems:
  • Windows Server 2022
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows 11
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7 SP1+
Microsoft SQL ServerThe Collection Server requires one of the following versions of Microsoft SQL Server:
  • SQL Server 2022
  • SQL Server 2019
  • SQL Server 2017
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012 SP1
  • SQL Server 2008 R2

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 2022
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012
  • Windows Server 2008 R211
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7 SP1+

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

...

Software TypeRequirement
Operating SystemThe agent requires one of the following operating systems:
  • Windows Server 2022
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012
  • Windows Server 2008 R211
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7 SP1+

...