Skip to content

MS SQL Server 2014 Instance Security Technical Implementation Guide

Rules, Groups, and Values defined within the XCCDF Benchmark

  • SQL Server must generate Trace or Audit records when unsuccessful attempts to add privileges/permissions occur.

    Failed attempts to change the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unauthorized attempts to elevate or restrict privileges could go...
    Rule Medium Severity
  • SRG-APP-000499-DB-000330

    Group
  • SRG-APP-000499-DB-000331

    Group
  • SQL Server must generate Trace or Audit records when unsuccessful attempts to delete privileges/permissions occur.

    Changes in the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unauthorized elevation or restriction of privileges could go undetected. Elevat...
    Rule Medium Severity
  • SRG-APP-000503-DB-000350

    Group
  • SQL Server must generate Trace or Audit records when successful logons or connections occur.

    For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to SQL Server. Use of SQL Server Audit is recommended. All features of SQL Server Audit...
    Rule Medium Severity
  • SRG-APP-000503-DB-000351

    Group
  • SQL Server must generate Trace or Audit records when unsuccessful logons or connection attempts occur.

    For completeness of forensic analysis, it is necessary to track failed attempts to log on to SQL Server. While positive identification may not be possible in a case of failed authentication, as muc...
    Rule Medium Severity
  • SRG-APP-000504-DB-000354

    Group
  • SRG-APP-000504-DB-000355

    Group
  • SQL Server must generate Trace or Audit records when unsuccessful attempts to execute privileged activities or other system-level access occur.

    Without tracking privileged activity, it would be difficult to establish, correlate, and investigate the events relating to an incident or identify those responsible for one. To aid in diagnosis,...
    Rule Medium Severity
  • SRG-APP-000505-DB-000352

    Group
  • SQL Server must generate Trace or Audit records when logoffs or disconnections occur.

    For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to and off from SQL Server. Use of SQL Server Audit is recommended. All features of SQ...
    Rule Medium Severity
  • SRG-APP-000506-DB-000353

    Group
  • SRG-APP-000515-DB-000318

    Group
  • SRG-APP-000164-DB-000401

    Group
  • If SQL Server authentication, using passwords, is employed, SQL Server must enforce the DoD standards for password complexity.

    Windows domain/enterprise authentication and identification must be used (SQL4-00-030300). Native SQL Server authentication may be used only when circumstances make it unavoidable; and must be doc...
    Rule Medium Severity
  • SRG-APP-000164-DB-000401

    Group
  • If SQL Server authentication, using passwords, is employed, SQL Server must enforce the DoD standards for password lifetime.

    Windows domain/enterprise authentication and identification must be used (SQL4-00-030300). Native SQL Server authentication may be used only when circumstances make it unavoidable; and must be doc...
    Rule Medium Severity
  • SRG-APP-000178-DB-000083

    Group

The content of the drawer really is up to you. It could have form fields, definition lists, text lists, labels, charts, progress bars, etc. Spacing recommendation is 24px margins. You can put tabs in here, and can also make the drawer scrollable.

Capacity
Modules