Page History
...
| SQL Server Version | Operating System |
|---|---|
| SQL Server 2017 | Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016 |
SQL Server 2016 | Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016 |
| SQL Server 2014 | Windows Server 2008, Windows Server 2012 |
| SQL Server 2012 SP1 | Windows Server 2008 SP2 |
| SQL Server 2008 R2 | Windows Server 2008 R2, Windows Server 2008 |
| SQL Server 2008 | Windows Server 2008 |
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 stores SQL Compliance Manager configurations and audit data. If you plan to audit instances running SQL Server 2005 or later, install the Ensure your Collection Server resides on a computer hosting version of SQL Server that is greater than or equal to the highest version of SQL Server running in your environmentaudited SQL Server version. 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 instanceif 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.
| Note |
|---|
The Repository must reside on a version of SQL Server that is greater than or equal to the highest audited SQL Server version. |
...