STIGhubSTIGhub
STIGsSearchCompareAbout

STIGhub

A free tool to search and browse the entire DISA STIG library. Saves up to 75% in security compliance research time.

Navigation

  • Browse STIGs
  • Search
  • Compare Versions

Resources

  • About
  • VPAT
  • DISA STIG Library
Powered by Pylon
© 2026 Beacon Cloud Solutions, Inc. All rights reserved.
← Back to STIGs

Microsoft SQL Server 2022 Database Security Technical Implementation Guide

Version

V1R3

Benchmark ID

MS_SQL_Server_2022_Database_STIG

Total Checks

23

Tags

database
CAT I: 4CAT II: 19CAT III: 0

This Security Technical Implementation Guide is published as a tool to improve the security of Department of Defense (DOD) information systems. The requirements are derived from the National Institute of Standards and Technology (NIST) 800-53 and related documents. Comments or proposed revisions to this document should be sent via email to the following address: disa.stig_spt@mail.mil.

Export CKLExport CSVExport JSON

Checks (23)

V-271118HIGHSQL Server must integrate with an organization-level authentication/access mechanism providing account management and automation for all users, groups, roles, and any other principals.V-271119HIGHSQL Server must enforce approved authorizations for logical access to information and system resources in accordance with applicable access control policies.V-271121MEDIUMSQL Server must protect against a user falsely repudiating by using system-versioned tables (Temporal Tables).V-271122MEDIUMSQL Server must protect against a user falsely repudiating by ensuring databases are not in a trust relationship.V-271124MEDIUMSQL Server must allow only the information system security manager (ISSM) (or individuals or roles appointed by the ISSM) to select which auditable events are to be audited.V-271143MEDIUMSQL Server must limit privileges to change software modules, to include stored procedures, functions, and triggers, and links to software external to SQL Server.V-271146MEDIUMDatabase objects (including but not limited to tables, indexes, storage, stored procedures, functions, triggers, links to software external to SQL Server, etc.) must be owned by database/DBMS principals authorized for ownership.V-271147MEDIUMThe role(s)/group(s) used to modify database structure (including but not limited to tables, indexes, storage, etc.) and logic modules (stored procedures, functions, triggers, links to software external to SQL Server, etc.) must be restricted to authorized users.V-271168MEDIUMIn the event of a system failure, hardware loss or disk failure, SQL Server must be able to restore necessary databases with least disruption to mission processes.V-271169MEDIUMThe Database Master Key encryption password must meet DOD password complexity requirements.V-271170MEDIUMThe Database Master Key must be encrypted by the Service Master Key, where a Database Master Key is required and another encryption method has not been specified.V-271171MEDIUMThe certificate used for encryption must be backed up and stored in a secure location that is not on the SQL Server.V-271172MEDIUMSQL Server must isolate security functions from nonsecurity functions.V-271173MEDIUMDatabase contents must be protected from unauthorized and unintended information transfer by enforcement of a data transfer policy.V-271176MEDIUMSQL Server must check the validity of all data inputs except those specifically identified by the organization.V-271179MEDIUMSQL Server must provide nonprivileged users with error messages that provide information necessary for corrective actions without revealing information that could be exploited by adversaries.V-271184MEDIUMSQL Server must associate organization-defined types of security labels having organization-defined security label values with information in process, transit, or storage.V-271186MEDIUMSQL Server must enforce discretionary access control (DAC) policies, as defined by the data owner, over defined subjects and objects.V-271188MEDIUMExecution of stored procedures and functions that use execute as must be restricted to necessary cases only.V-271195MEDIUMSQL Server must enforce access restrictions associated with changes to the configuration of the database(s).V-271199HIGHSQL Server must use NSA-approved cryptography to protect classified information in accordance with the data owner’s requirements.V-271201HIGHSQL Server must implement cryptographic mechanisms to prevent unauthorized modification or disclosure of organization-defined information at rest (to include, at a minimum, PII and classified information) on organization-defined information system components.V-283667MEDIUMSQL Server must protect against a user falsely repudiating by ensuring that only unique Active Directory user accounts can connect to the database.