MSSQL Server - Surface Area Configuration


Carry out the procedure given below to enable the option Using both TCP/IP and named pipes in Remote Connections. This configuration is applicable for SQL Server 2005 & above. 

  1. In the SQL Server 2005 Surface Area Configuration configuration screen, select MSSQLSERVER > Database Engine > Remote Connections component on the left side of the configuration screen.
  2. Select the Local and remote connections > Using both TCP/IP and named pipes option on the right side of the screen.

Refer the screen shot given below.

Surface are configuration of MSSQL server in Firewall Analyzer: Localhost setup

 

A single platter for comprehensive Network Security Device Management