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

Access to nonstandard, extended stored procedures must be disabled or restricted, unless specifically required and approved.

DISA Rule

SV-271300r1109264_rule

Vulnerability Number

V-271300

Group Title

SRG-APP-000141-DB-000093

Rule Version

SQLI-22-007400

Severity

CAT II

CCI(s)

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

Weight

10

Fix Recommendation

Remove any nonstandard extended stored procedures that are not documented and approved using the following:

sp_dropextendedproc 'proc name'

Check Contents

Extended stored procedures are DLLs that an instance of SQL Server can dynamically load and run. Extended stored procedures run directly in the address space of an instance of SQL Server and are programmed by using the SQL Server Extended Stored Procedure API.

Nonstandard extended stored procedures can compromise the integrity of the SQL Server process. This feature will be removed in a future version of SQL Server. Do not use this feature in new development work and modify applications that currently use this feature as soon as possible.

To determine if nonstandard extended stored procedures exist, run the following:

USE [master]
GO
DECLARE @xplist AS TABLE
(
xp_name sysname,
source_dll nvarchar(255)
)
INSERT INTO @xplist
EXEC sp_helpextendedproc

SELECT X.xp_name, X.source_dll, O.is_ms_shipped FROM @xplist X JOIN sys.all_objects O ON X.xp_name = O.name WHERE O.is_ms_shipped = 0 ORDER BY X.xp_name

If any records are returned, review the system documentation to determine whether the use of nonstandard extended stored procedures are required and approved.

If it is not approved, this is a finding.

Vulnerability Number

V-271300

Documentable

False

Rule Version

SQLI-22-007400

Severity Override Guidance

Extended stored procedures are DLLs that an instance of SQL Server can dynamically load and run. Extended stored procedures run directly in the address space of an instance of SQL Server and are programmed by using the SQL Server Extended Stored Procedure API.

Nonstandard extended stored procedures can compromise the integrity of the SQL Server process. This feature will be removed in a future version of SQL Server. Do not use this feature in new development work and modify applications that currently use this feature as soon as possible.

To determine if nonstandard extended stored procedures exist, run the following:

USE [master]
GO
DECLARE @xplist AS TABLE
(
xp_name sysname,
source_dll nvarchar(255)
)
INSERT INTO @xplist
EXEC sp_helpextendedproc

SELECT X.xp_name, X.source_dll, O.is_ms_shipped FROM @xplist X JOIN sys.all_objects O ON X.xp_name = O.name WHERE O.is_ms_shipped = 0 ORDER BY X.xp_name

If any records are returned, review the system documentation to determine whether the use of nonstandard extended stored procedures are required and approved.

If it is not approved, this is a finding.

Check Content Reference

M

Target Key

5677