UCF STIG Viewer Logo

MS SQL Server Instance name should not incude a SQL Server or other software version number.


Overview

Finding ID Version Rule ID IA Controls Severity
V-2436 DM0660-SQLServer9 SV-23762r2_rule ECAN-1 Medium
Description
The use of version numbers within the database instance name restricts the use of the instance name from meaningful use in subsequent upgrades. Changing the database instance names on a production database causes unnecessary administrative overhead and compromise existing secure network configurations.
STIG Date
Microsoft SQL Server 2005 Instance Security Technical Implementation Guide 2015-06-16

Details

Check Text ( C-13603r2_chk )
From the query prompt:

SELECT RTRIM(CONVERT(CHAR(20), SERVERPROPERTY('instancename')))

If the instance name contains the SQL Server version number, this is a Finding.
Fix Text (F-23520r1_fix)
Do not use version number references in instance names.

The instance name cannot be changed on an existing instance.

A new instance can be created with a compliant name and the databases moved.