Skip to content

MS SQL Server 2014 Instance Security Technical Implementation Guide

Rules, Groups, and Values defined within the XCCDF Benchmark

  • SRG-APP-000141-DB-000090

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the SQL Server Analysis Services (SSAS) software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the publicly available AdventureWorks sample database removed.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the SQL Server Data Tools (SSDT) software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the SQL Server Reporting Services (SSRS) software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the SQL Server Integration Services (SSIS) software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the SQL Server Distributed Replay Client software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the SQL Server Distributed Replay Controller software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the Full-Text Search software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the Master Data Services software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the SQL Server Replication software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the Data Quality Client software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the Data Quality Services software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the Client Tools SDK software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the Management Tools software component removed if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000091

    <GroupDescription></GroupDescription>
    Group
  • Access to database files must be limited to relevant processes and to authorized, administrative users.

    &lt;VulnDiscussion&gt;Applications, including DBMSs, must prevent unauthorized and unintended information transfer via shared system resources. Per...
    Rule Medium Severity
  • SRG-APP-000295-DB-000305

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must have the Filestream feature disabled if it is unused.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000141-DB-000092

    <GroupDescription></GroupDescription>
    Group
  • Unused database components that are integrated in SQL Server and cannot be uninstalled must be disabled.

    &lt;VulnDiscussion&gt;SQL Server is capable of providing a wide variety of functions and services. Some of the functions and services, provided by ...
    Rule Medium Severity
  • SRG-APP-000141-DB-000092

    <GroupDescription></GroupDescription>
    Group
  • The SQL Server default account [sa] must be disabled.

    &lt;VulnDiscussion&gt;SQL Server's [sa] account has special privileges required to administer the database. The [sa] account is a well-known SQL Se...
    Rule Medium Severity
  • SRG-APP-000141-DB-000093

    <GroupDescription></GroupDescription>
    Group
  • Access to xp_cmdshell must be disabled, unless specifically required and approved.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000142-DB-000094

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must be configured to prohibit or restrict the use of unauthorized network protocols.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000142-DB-000094

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must be configured to prohibit or restrict the use of unauthorized network ports.

    &lt;VulnDiscussion&gt;Information systems are capable of providing a wide variety of functions and services. Some of the functions and services, pr...
    Rule Medium Severity
  • SRG-APP-000148-DB-000103

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must uniquely identify and authenticate organizational users (or processes acting on behalf of organizational users).

    &lt;VulnDiscussion&gt;To ensure accountability and prevent unauthorized SQL Server access, organizational users shall be identified and authenticat...
    Rule Medium Severity
  • SRG-APP-000180-DB-000115

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must uniquely identify and authenticate non-organizational users (or processes acting on behalf of non-organizational users).

    &lt;VulnDiscussion&gt;Non-organizational users include all information system users other than organizational users, which include organizational e...
    Rule Medium Severity
  • SRG-APP-000211-DB-000122

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must be configured to separate user functionality (including user interface services) from database management functionality.

    &lt;VulnDiscussion&gt;Information system management functionality includes functions necessary to administer databases, network components, worksta...
    Rule Medium Severity
  • SRG-APP-000233-DB-000124

    <GroupDescription></GroupDescription>
    Group
  • SQL Server must isolate security functions from nonsecurity functions.

    &lt;VulnDiscussion&gt;An isolation boundary provides access control and protects the integrity of the hardware, software, and firmware that perform...
    Rule Medium Severity

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