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

Filestream must be disabled unless specifically required and approved.

DISA Rule

SV-274450r1111117_rule

Vulnerability Number

V-274450

Group Title

SRG-APP-000141-DB-000093

Rule Version

SQLI-22-016800

Severity

CAT II

CCI(s)

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

Weight

10

Fix Recommendation

Disable the use of Filestream.

1. Delete all FILESTREAM columns from all tables. ALTER TABLE <name> DROP COLUMN <column name>
2. Disassociate tables from the FILESTREAM filegroups. ALTER TABLE <name> SET (FILESTREAM_ON = 'NULL'
3. Remove all FILESTREAM data containers. ALTER DATABASE <name> REMOVE FILE <file name>
4. Remove all FILESTREAM filegroups. ALTER DATABASE <name> REMOVE FILEGROUP <file name>
5. Disable FILESTREAM.
EXEC sp_configure filestream_access_level, 0
RECONFIGURE
6. Restart the SQL Service.

Check Contents

Review the system documentation to determine if FileStream is in use. If in use and authorized, this is not a finding.

If FileStream is not documented as being authorized, execute the following query:
EXEC sp_configure 'filestream access level'

If "run_value" is greater than "0", this is a finding.

This rule checks that the Filestream SQL-specific option is disabled.
SELECT CASE
WHEN EXISTS (SELECT *
FROM sys.configurations
WHERE Name = 'filestream access level'
AND Cast(value AS INT) = 0) THEN 'No'
ELSE 'Yes'
END AS TSQLFileStreamAccess;

If the above query returns "Yes" in the "FileStreamEnabled" field, this is a finding.

Vulnerability Number

V-274450

Documentable

False

Rule Version

SQLI-22-016800

Severity Override Guidance

Review the system documentation to determine if FileStream is in use. If in use and authorized, this is not a finding.

If FileStream is not documented as being authorized, execute the following query:
EXEC sp_configure 'filestream access level'

If "run_value" is greater than "0", this is a finding.

This rule checks that the Filestream SQL-specific option is disabled.
SELECT CASE
WHEN EXISTS (SELECT *
FROM sys.configurations
WHERE Name = 'filestream access level'
AND Cast(value AS INT) = 0) THEN 'No'
ELSE 'Yes'
END AS TSQLFileStreamAccess;

If the above query returns "Yes" in the "FileStreamEnabled" field, this is a finding.

Check Content Reference

M

Target Key

5677