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.