Home » Other Tools and Utilities

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.


MSSQL Remote Connections Configuration

Copyright © 2014, ZOHO Corp. All Rights Reserved.