STIGQter: STIG Summary: MS SQL Server 2014 Instance Security Technical Implementation Guide Version: 1 Release: 10 Benchmark Date: 24 Apr 2020:

SQL Server must have the publicly available pubs sample database removed.

DISA Rule

SV-82309r1_rule

Vulnerability Number

V-67819

Group Title

SRG-APP-000141-DB-000090

Rule Version

SQL4-00-016300

Severity

CAT II

CCI(s)

• CCI-000381 - The organization configures the information system to provide only essential capabilities.

Weight

10

Fix Recommendation

Remove the publicly available "pubs" database from SQL Server by running the following script:

USE master;
GO
DROP DATABASE pubs;
GO

Check Contents

Check SQL Server for the existence of the publicly available "pubs" database by performing the following query:

SELECT name FROM sysdatabases WHERE name LIKE 'pubs%';

If the "pubs" database is present, this is a finding.

Vulnerability Number

V-67819

Documentable

False

Rule Version

SQL4-00-016300

Severity Override Guidance

Check SQL Server for the existence of the publicly available "pubs" database by performing the following query:

SELECT name FROM sysdatabases WHERE name LIKE 'pubs%';

If the "pubs" database is present, this is a finding.

Check Content Reference

M

Target Key

2639

Comments