Sunset - CIS SQL Server 2017 Database L1 DB v1.2.0

Audit Details

Name: Sunset - CIS SQL Server 2017 Database L1 DB v1.2.0

Updated: 6/27/2023

Authority: CIS

Plugin: Database

Revision: 1.7

Audit Changelog

 
Revision 1.8

Jun 17, 2024

Miscellaneous
  • Audit deprecated.
  • Metadata updated.
  • References updated.
Revision 1.7

Jun 27, 2023

Miscellaneous
  • Metadata updated.
Revision 1.6

Mar 7, 2023

Miscellaneous
  • Metadata updated.
  • References updated.
Revision 1.5

Feb 13, 2023

Functional Update
  • 2.11 Ensure SQL Server is configured to use non-standard ports
  • 3.2 Ensure CONNECT permissions on the 'guest' user is Revoked within all SQL Server databases excluding the master, msdb and tempdb
  • 3.3 Ensure 'Orphaned Users' are Dropped From SQL Server Databases
  • 3.4 Ensure SQL Authentication is not used in contained databases
  • 7.1 Ensure 'Symmetric Key encryption algorithm' is set to 'AES_128' or higher in non-system databases
  • 7.2 Ensure Asymmetric Key Size is set to 'greater than or equal to 2048' in non-system databases
Revision 1.4

Jan 4, 2023

Miscellaneous
  • Metadata updated.
  • Variables updated.
Revision 1.3

Dec 7, 2022

Miscellaneous
  • Metadata updated.
Revision 1.2

Apr 25, 2022

Miscellaneous
  • Metadata updated.
Revision 1.1

Mar 29, 2022

Miscellaneous
  • Metadata updated.
  • References updated.