SV-276320r1149869_rule
V-276320
SRG-APP-000141-DB-000093
MSQL-D0-017300
CAT II
10
To enable the use of CLR Strict Security, from the query prompt:
EXEC SP_CONFIGURE 'show advanced options', 1;
RECONFIGURE WITH OVERRIDE;
EXEC SP_CONFIGURE 'CLR Strict Security', 1;
RECONFIGURE WITH OVERRIDE;
EXEC SP_CONFIGURE 'show advanced options', 0;
RECONFIGURE WITH OVERRIDE;
Reference: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/clr-strict-security?
The CLR Strict Security option can be disabled for backward compatibility, but this is not recommended.
To determine if CLR Strict Security is enabled, execute the following command:
SELECT name, value, value_in_use
FROM sys.configurations
WHERE name = 'CLR Strict Security'
If "value_in_use" is a "0", review the system documentation to determine whether the use of CLR Strict Security is not required and approved. If it is not approved to be disabled, this is a finding.
V-276320
False
MSQL-D0-017300
The CLR Strict Security option can be disabled for backward compatibility, but this is not recommended.
To determine if CLR Strict Security is enabled, execute the following command:
SELECT name, value, value_in_use
FROM sys.configurations
WHERE name = 'CLR Strict Security'
If "value_in_use" is a "0", review the system documentation to determine whether the use of CLR Strict Security is not required and approved. If it is not approved to be disabled, this is a finding.
M
5711