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.