STIGQter: STIG Summary: Microsoft SQL Server 2022 Instance Security Technical Implementation Guide Version: 1 Release: 4 Benchmark Date: 01 Apr 2026:

Access to common language runtime (CLR) code must be disabled or restricted unless specifically required and approved.

DISA Rule

SV-271301r1109114_rule

Vulnerability Number

V-271301

Group Title

SRG-APP-000141-DB-000093

Rule Version

SQLI-22-007300

Severity

CAT II

CCI(s)

• CCI-000381 - Configure the system to provide only organization-defined mission essential capabilities.

Weight

10

Fix Recommendation

Disable use of or remove any CLR code that is not authorized.

To disable the use of CLR, from the query prompt:

EXEC SP_CONFIGURE 'clr enabled', 0;
RECONFIGURE WITH OVERRIDE;

For any approved CLR code with Unsafe or External permissions, use the ALTER ASSEMBLY to change the permission set for the assembly and ensure a certificate is configured.

Check Contents

To determine if [CLR] is enabled, execute the following command:

SELECT name, value, value_in_use
FROM sys.configurations
WHERE name = 'clr enabled'

If [value_in_use] is a [1], review the system documentation to determine whether the use of [CLR] is approved. If it is not approved, this is a finding.

Vulnerability Number

V-271301

Documentable

False

Rule Version

SQLI-22-007300

Severity Override Guidance

To determine if [CLR] is enabled, execute the following command:

SELECT name, value, value_in_use
FROM sys.configurations
WHERE name = 'clr enabled'

If [value_in_use] is a [1], review the system documentation to determine whether the use of [CLR] is approved. If it is not approved, this is a finding.

Check Content Reference

M

Target Key

5677