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

The "Hadoop Connectivity" feature must be disabled unless specifically required and approved.

DISA Rule

SV-271297r1111129_rule

Vulnerability Number

V-271297

Group Title

SRG-APP-000141-DB-000093

Rule Version

SQLI-22-017400

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 external application executable object definitions that are not approved.

To disable the use of [Hadoop Connectivity] option, from the query prompt:
EXEC SP_CONFIGURE 'hadoop connectivity', 0;
RECONFIGURE WITH OVERRIDE;

Check Contents

To determine if [Hadoop Connectivity] is enabled, execute the following command:
SELECT name, value, value_in_use
FROM sys.configurations
WHERE name = 'Hadoop Connectivity'

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

Vulnerability Number

V-271297

Documentable

False

Rule Version

SQLI-22-017400

Severity Override Guidance

To determine if [Hadoop Connectivity] is enabled, execute the following command:
SELECT name, value, value_in_use
FROM sys.configurations
WHERE name = 'Hadoop Connectivity'

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

Check Content Reference

M

Target Key

5677