Detections
Analytics

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

Audit Details

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

Updated: 6/27/2023

Authority: CIS

Plugin: Database

Revision: 1.10

File Details

Filename: CIS_Microsoft_SQL_Server_2019_Database_v1.2.0_Level_1_DB.audit

Size: 91.4 kB

MD5: 9c059d775cbebb6706bc5ea38c01344d
SHA256: 69a5b27f311a791d965707ffabc5227c76d3eed54a983d9c8806b77fa0391fc4

Audit Changelog

 
Revision 1.10

Jun 27, 2023

Miscellaneous
  • Metadata updated.
Revision 1.9

Mar 7, 2023

Miscellaneous
  • Metadata updated.
  • References updated.
Revision 1.8

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.7

Jan 4, 2023

Miscellaneous
  • Metadata updated.
  • Variables updated.
Revision 1.6

Dec 7, 2022

Miscellaneous
  • Metadata updated.
Revision 1.5

Nov 4, 2022

Functional Update
  • 6.2 Ensure 'CLR Assembly Permission Set' is set to 'SAFE_ACCESS' for All CLR Assemblies
Revision 1.4

May 17, 2022

Removed
  • 3.5 Ensure the SQL Server's MSSQL Service Account is Not an Administrator
  • 3.6 Ensure the SQL Server's SQLAgent Service Account is Not an Administrator
  • 3.7 Ensure the SQL Server's Full-Text Service Account is Not an Administrator
Revision 1.3

Apr 25, 2022

Miscellaneous
  • Metadata updated.
Revision 1.2

Mar 29, 2022

Miscellaneous
  • Metadata updated.
  • References updated.
Revision 1.1

Aug 2, 2021

Functional Update
  • 6.2 Ensure 'CLR Assembly Permission Set' is set to 'SAFE_ACCESS' for All CLR Assemblies