Detections
Analytics
SQLI-22-016600 - The SQL Server Service Broker endpoint must use AES encryption.
Information
Information can be unintentionally or maliciously disclosed or modified during preparation for transmission, including, for example, during aggregation, at protocol transformation points, and during packing/unpacking. These unauthorized disclosures or modifications compromise the confidentiality or integrity of the information.Use of this requirement will be limited to situations where the data owner has a strict requirement for ensuring that data integrity and confidentiality is maintained at every step of the data transfer and handling process.
SQL Server Service Broker endpoints support different encryption algorithms, including no-encryption. Using a weak encryption algorithm or plaintext in communication protocols can lead to data loss, data manipulation, and/or connection hijacking.
Solution
Run the following to enable encryption on the Service Broker endpoint:ALTER ENDPOINT <EndpointName>
FOR SERVICE_BROKER
(ENCRYPTION = REQUIRED ALGORITHM AES)
See Also
https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MS_SQL_Server_2022_Y26M04_STIG.zip
Item Details
Category: CONFIGURATION MANAGEMENT
References: 800-53|CM-6b., CAT|II, CCI|CCI-000366, Rule-ID|SV-274448r1111112_rule, STIG-ID|SQLI-22-016600, Vuln-ID|V-274448
Plugin: MS_SQLDB
Control ID: 4eb01730110cd57ff5aaa739a8477bfd5c3c53fbb9643aa0663f415b8835bd0d