SQL4-00-034200 - SQL Server must disable communication protocols not required for operation.

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

Having unnecessary protocols enabled exposes the system to avoidable threats. In a typical installation, only TCP/IP will be required.

NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.

Solution

In SQL Server Configuration Manager, right-click on each enabled protocol that is not required. Select Disabled.

Close SQL Server Configuration Manager. Restart SQL Server.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MS_SQL_Server_2014_Y22M10_STIG.zip