[Survey] The 2025 Observability Survey - Share your opinion and earn $10.Take the survey

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.

 

Back to Top