Microsoft SQL Server
TMA-MSSQL2022-2.10
Ensure Unnecessary SQL Server Protocols are set to 'Disabled'
LowLevel 1Manual reviewmssql
Description
SQL Server supports Shared Memory, Named Pipes, and TCP/IP protocols. However, SQL Server should be configured to use the bare minimum required based on the organization's needs. Using fewer protocols minimizes the attack surface of SQL Server and, in some cases, can protect it from remote attacks.
How it is checked
Audit method: Manual review
This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.
Open SQL Server 2022 Configuration Manager; go to the SQL Server Network Configuration. Ensure that only required protocols are enabled.
How it is fixed
Fix method: Guidance or infrastructure patch
Open SQL Server 2022 Configuration Manager; go to the SQL Server Network Configuration. Ensure that only required protocols are enabled. Disable protocols not necessary.
Properties
- Operating systems
- Any
- Tags
- mssqlsqlserver-2022
- Reference
- CIS Microsoft SQL Server 2022 Benchmark v1.3.0 - 2.10 Ensure Unnecessary SQL Server Protocols are set to 'Disabled'