BigFix Compliance: Updated CIS Checklist for MS SQL Server 2022, published 2025.06.24

Product:
BigFix Compliance

Title:
Updated CIS Checklist for MS SQL Server 2022 to support a more recent version of the benchmark

Security Benchmark:
CIS Microsoft SQL Server 2022 Benchmark, V1.2.0

Published Sites:
CIS Checklist for MS SQL Server 2022, site version 8
(The site version is provided for air-gap customers.)

Details:

Total New Fixlets: 0

Total Updated Fixlets:5

Total Deleted Fixlets: 0

Total Fixlets in Site: 44

Updated:

  • 3.5 Ensure the SQL Server’s MSSQL Service Account is Not an Administrator
  • 3.13 Ensure membership in admin roles in MSDB database is limited
  • 5.1 Ensure ‘Maximum number of error log files’ is set to greater than or equal to ‘12’
  • 7.3 Ensure Database Backups are Encrypted
  • 7.4 Ensure Network Encryption is Configured and Enabled

Applicable for MS windows server 2025.

Both analysis and remediation checks are included

Some of the checks allow you to use the parameterized setting to enable customization for compliance evaluation. Note that parameterization and remediation actions require the creation of a custom site.

Actions to take:

To subscribe to the above site, you can use the License Overview Dashboard to enable and gather the site. Note that you must be entitled to the BigFix Compliance product, and you must be using BigFix version 10 and later.

If you use custom sites, update your custom sites accordingly to use the latest content. You can synchronize your content by using the Synchronize Custom Checks wizard. For more information, see

More information:
To know more about the BigFix Compliance SCM checklists, please see the following resources:

BigFix Forum:

BigFix Compliance SCM Checklists:
https://bigfix-wiki.hcltechsw.com/wikis/home?lang=en-us#!/wiki/BigFix%20Wiki/page/SCM%20Checklists

We hope you find this latest release of SCM content useful and effective. Thank you!
– The BigFix Compliance team