2.10 Ensure Unnecessary SQL Server Protocols are set to 'Disabled'
Information
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. NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.
Solution
Open SQL Server Configuration Manager ; go to the SQL Server Network Configuration Ensure that only required protocols are enabled. Disable protocols not necessary. Impact: The Database Engine (MSSQL and SQLAgent) services must be stopped and restarted for the change to take effect.