cms-ars-3.1-high-aws-rds-microsoft-sql-server-2014-instance-stig-overlay

CMS’ ISPG (Information Security and Privacy Group) decided to discontinue funding the customization of MITRE’s Security Automation Framework (SAF) for CMS after September 2023. This repo is now in archive mode, but still accessible. For more information about SAF with current links, see https://security.cms.gov/learn/security-automation-framework-saf

InSpec profile overlay to validate the secure configuration of AWS RDS Microsoft SQL Server 2014 Instance against DISA's AWS RDS Microsoft SQL Server 2014 Instance STIG Version 1 Release 9 tailored for CMS ARS 3.1 for CMS systems categorized as High.

Getting Started

It is intended and recommended that InSpec and this profile overlay be run from a "runner" host (such as a DevOps orchestration server, an administrative management system, or a developer's workstation/laptop) against the target remotely over ssh.

For the best security of the runner, always install on the runner the latest version of InSpec and supporting Ruby language components.

Latest versions and installation options are available at the InSpec site.

Tailoring to Your Environment

The following inputs must be configured in an inputs ".yml" file for the profile to run correctly for your specific environment. More information about InSpec inputs can be found in the InSpec Profile Documentation.

# Description: Username for MSSQL DB Server (e.g., null).
user: 

# Description: Password for MSSQL DB Server (e.g., null).
password: 

# Description: Hostname for MSSQL DB Server (e.g., 'hostname').
host: 

# Description: Instance name of the MSSQL DB Server (e.g., 'MSSQL2014').
instance: ''

# Description: Port of MSSQL DB Server
port: 1433

# Description: Name of the specific database being evaluated within the MSSQL server (e.g., 'master').
db_name: ''

# Description: Set to true if SQL Server Trace is in use for audit purposes
server_trace_implemented: false

# Description: Set to true if SQL Server Audit is in use for audit purposes
server_audit_implemented: false

# Description: Set to true if SQL Server Reporting Services is in use
sql_server_reporting_services_used: false

# Description: Set to true if SQL Server data tools is required
sql_server_data_tools_required: false

# Description: Set to true if SQL Server Integration Services is in use
sql_server_integration_services_used: false

# Description: Set to true if SQL Server analysis Services is in use
sql_server_analysis_services_used: false

# Description: Set to true if SQL Server Distributed Replay Client is in use
sql_server_distributed_replay_client_used: false

# Description: Set to true if SQL Server Distributed Replay Controller is in use
sql_server_distributed_replay_controller_used: false

# Description: Set to true if SQL Server full-text search is in use
sql_server_full_text_search_used: false

# Description: Set to true if master data services is in use
master_data_services_used: false

# Description: Set to true if data quality client is in use
data_quality_client_used: false

# Description: Set to true if data quality services is in use
data_quality_services_used: false

# Description: Set to true if data quality services is in use
data_quality_services_used: false

# Description: Set to true if client tools SDK is in use
client_tools_sdk_used: false

# Description: Set to true if SQL server management tools is in use
sql_mgmt_tools_used: false

# Description: Set to true if xp_cmdhsell is required
sql_mgmt_tools_used: false

# Description: instance name MSSQL DB Server (e.g., 'WIN-FC4ANINFUFP')
server_instance: ''

# Description: List of users with permissions (e.g., ['ALTER TRACE', 'CREATE TRACE EVENT NOTIFICATION'])
approved_audit_maintainers: []

# Description: List of users with audit permissions (e.g., ['ALTER ANY SERVER AUDIT', 'CONTROL SERVER', 'ALTER ANY DATABASE', 'CREATE ANY DATABASE'])
allowed_audit_permissions: []

# Description: List of user with permissions (e.g., ['ALTER ANY SERVER AUDIT', 'ALTER ANYDATABASE AUDIT', 'ALTER TRACE', 'EXECUTE'])
allowed_sql_alter_permissions: []

# Description: List of approved users with access to SQL Server Audits
approved_users_sql_audits: []

# Description: List of SQL server users with permissions (e.g., ['alter', 'create', control'])
approved_users_server: []

# Description: List of SQL database users with permissions (e.g., ['alter', 'create', 'control'])
approved_users_database: []

# Description: List of SQL components installed
sql_components: []

#  Description: List of authorized network protocols for the SQL server (e.g., ['Shared Memory', 'TCP/IP'])
authorized_protocols: []

# Description: List of authorized network ports for the SQL server (e.g., ['1433'])
authorized_ports: []      

# Description: List of authorized network port names for the SQL server (e.g., ['TcpPort', 'TcpDynamicPorts'])
authorized_ports_name: []  

# Description: List of authorized users for the SQL server
authorized_sql_users: []

# Description: List of users allowed to execute privileged functions  (e.g., ['create', 'alter', 'delete'])
allowed_users_priv_functions: []

# Description: List of allowed server permissions
allowed_server_permissions: []

# Description: List of allowed database permissions
allowed_database_permissions: []

# Description: List of Databases that require encryption
encrypted_databases: []

# Description: Set to true if data at rest encryption is required
data_at_rest_encryption_required: false

# Description: Set to true if full disk encryption is in place
full_disk_encryption_inplace: false

# Description: List of user allowed to execute privileged functions
allowed_users: []

# Description: Set to true xp cmdshell is required
is_xp_cmdshell_required: false

# Description: List of accounts managed by the SQL server
sql_managed_accounts: []

# Description: Set to true if filestream is required
filestream_required: false

# Description: Set to true if filestream transact access is required
filestream_transact_access_only_required: false

Running This Overlay Directly from Github

# How to run
inspec exec https://github.com/CMSgov/cms-ars-3.1-high-aws-rds-microsoft-sql-server-2014-instance-stig-overlay/archive/master.tar.gz --input-file=<path_to_your_inputs_file/name_of_your_inputs_file.yml> --reporter=cli json:<path_to_your_output_file/name_of_your_output_file.json>

Different Run Options

Full exec options

Running This Overlay from a local Archive copy

If your runner is not always expected to have direct access to GitHub, use the following steps to create an archive bundle of this overlay and all of its dependent tests:

(Git is required to clone the InSpec profile using the instructions below. Git can be downloaded from the Git site.)

When the "runner" host uses this profile overlay for the first time, follow these steps:

mkdir profiles
cd profiles
git clone https://github.com/CMSgov/cms-ars-3.1-high-aws-rds-microsoft-sql-server-2014-instance-stig-overlay.git
inspec archive cms-ars-3.1-high-aws-rds-microsoft-sql-server-2014-instance-stig-overlay 
inspec exec <name of generated archive> --input-file=<path_to_your_inputs_file/name_of_your_inputs_file.yml> --reporter=cli json:<path_to_your_output_file/name_of_your_output_file.json>

For every successive run, follow these steps to always have the latest version of this overlay and dependent profiles:

cd profiles/aws-rds-microsoft-sql-server-2014-instance-stig-baseline
git pull
cd ..
inspec archive cms-ars-3.1-high-aws-rds-microsoft-sql-server-2014-instance-stig-overlay --overwrite
inspec exec <name of generated archive> --input-file=<path_to_your_inputs_file/name_of_your_inputs_file.yml> --reporter=cli json:<path_to_your_output_file/name_of_your_output_file.json>

Using Heimdall for Viewing the JSON Results

The JSON results output file can be loaded into heimdall-lite for a user-interactive, graphical view of the InSpec results.

The JSON InSpec results file may also be loaded into a full heimdall server, allowing for additional functionality such as to store and compare multiple profile runs.

Authors

Eugene Aronne - ejaronne
Danny Haynes - djhaynes

Special Thanks

Alicia Sturtevant - asturtevant
Shivani Karikar - karikarshivani

Contributing and Getting Help

To report a bug or feature request, please open an issue.

NOTICE

Approved for Public Release; Distribution Unlimited. Case Number 18-3678.

NOTICE

MITRE hereby grants express written permission to use, reproduce, distribute, modify, and otherwise leverage this software to the extent permitted by the licensed terms provided in the LICENSE.md file included with this project.

NOTICE

This software was produced for the U. S. Government under Contract Number HHSM-500-2012-00008I, and is subject to Federal Acquisition Regulation Clause 52.227-14, Rights in Data-General.

No other use other than that granted to the U. S. Government, or to those acting on behalf of the U. S. Government under that Clause is authorized without the express written permission of The MITRE Corporation.

For further information, please contact The MITRE Corporation, Contracts Management Office, 7515 Colshire Drive, McLean, VA 22102-7539, (703) 983-6000.

NOTICE

DISA STIGs are published by DISA IASE, see: https://iase.disa.mil/Pages/privacy_policy.aspx

cmsgov / cms-ars-3.1-high-aws-rds-microsoft-sql-server-2014-instance-stig-overlay Goto Github PK