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

Audit Changelog


Revision 1.11 Jun 17, 2024 Miscellaneous Audit deprecated. Metadata updated. References updated.
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.