SV-271304r1109265_rule
V-271304
SRG-APP-000142-DB-000094
SQLI-22-007600
CAT II
10
Navigate to SQL Server Configuration Manager >> SQL Server Network Configuration >> Protocols, then right-click on each listed protocol that is enabled but not authorized and select "Disable".
To determine the protocol(s) enabled for SQL Server, open SQL Server Configuration Manager. In the left pane, expand SQL Server Network Configuration. Click on the entry for the SQL Server instance under review: "Protocols for". The right-side pane displays the protocols enabled for the instance.
Alternatively, run the following SQL Script and review the registry_key for enabled protocols.
SELECT
*
FROM sys.dm_server_registry
WHERE registry_key like 'HKLM\Software\Microsoft\Microsoft SQL Server\%\MSSQLServer\SuperSocketNetLib\%'
AND value_name = 'enabled'
AND value_data = 1
If any listed protocols are enabled but not documented and authorized, this is a finding.
V-271304
False
SQLI-22-007600
To determine the protocol(s) enabled for SQL Server, open SQL Server Configuration Manager. In the left pane, expand SQL Server Network Configuration. Click on the entry for the SQL Server instance under review: "Protocols for". The right-side pane displays the protocols enabled for the instance.
Alternatively, run the following SQL Script and review the registry_key for enabled protocols.
SELECT
*
FROM sys.dm_server_registry
WHERE registry_key like 'HKLM\Software\Microsoft\Microsoft SQL Server\%\MSSQLServer\SuperSocketNetLib\%'
AND value_name = 'enabled'
AND value_data = 1
If any listed protocols are enabled but not documented and authorized, this is a finding.
M
5677