To enable named pipe connections in SQL Server 2008 R2, perform the following steps:

1.   On the computer running SQL Server 2008 R2 that hosts the database to be queried, click Start, and then point to All Programs. Point to Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.

2.   In the Microsoft SQL Server Management Studio console, in the Object Explorer, right-click sql_server_name, and then click Properties (where sql_server_name is the name of the computer running SQL Server to be configured).

3.   The Server Properties - sql_server_name dialog box is displayed.

4.   In the Server Properties - sql_server_name dialog box, in Select a page, click Connections.

5.   On the Connections page, ensure the Allow remote connections to this server check box is selected and then click OK.

6.   Close the Microsoft SQL Server Management Studio console.

7.   On the computer running SQL Server 2008 R2 that hosts the database to be queried, click Start, and then point to All Programs. Point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

8.   In the Sql Server Configuration Manager console, go to SQL Server Configuration Manager (Local) / SQL Server Network Configuration / Protocols for sql_instance (where sql_instance in the name of the SQL Server instance to be configured).

9.   In the details pane, right-click Named Pipes, and then click Enable.

The Warning dialog box appears indicating that the changes will be saved but will not take effect until the service is stopped and restarted.

10. In the Warning dialog box, click OK.

11. In the Sql Server Configuration Manager console, go to SQL Server Configuration Manager (Local) / SQL Server Services.

12. In the details pane, right-click SQL Server (sql_instance), and then click Restart (where sql_instance in the name of the SQL Server instance that you configured in step 2).

The SQL Server Configuration Manager progress bar is displayed that shows the status of restarting the services. After the service restarts, the progress bar closes.

13. Close the Sql Server Configuration Manager console.

For additional information, How to enable remote connections in SQL Server 2008.

Related Topics

Named Pipe Connections