TMA-MSSQL-2.10
Ensure Unnecessary SQL Server Protocols are set to 'Disabled'
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. Default: By default, TCP/IP and Shared Memory protocols are enabled on all commercial editions.
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 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 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
- mssqldatabasemanual
- Reference
- CIS Microsoft SQL Server 2025 Benchmark v1.0.0 - 2.10 Ensure Unnecessary SQL Server Protocols are set to 'Disabled'