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

1.   On the computer running SQL Server 2005 that hosts the database to be queried, click Start, and then point to All Programs. Point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.

2.   In the SQL Server 2005 Surface Area Configuration dialog box, click Surface Area Configuration for Services and Connections.

3.   In the Surface Area Configuration for Services and Connections – server_name dialog box (where server_name is the name of the computer running SQL Server 2005), in Select a component and then configure its services and connections, go to MSSQLSERVER\Database Engine, and then click Remote Connections.

4.   Click Local and remote connections, click Using both TCP/IP and named pipes, and then click Apply.

5.   In the Surface Area Configuration for Services and Connections – server_name dialog box (where server_name is the name of the computer running SQL Server 2005), in Select a component and then configure its services and connections, go to MSSQLSERVER\Database Engine, and then click Service.

6.   Click Stop.

The MSSQLSERVER service stops.

7.   Click Start.

The MSSQLSERVER service starts.

8.   Click OK.

9.   Close SQL Server 2005 Surface Area Configuration.

For additional information, see the Microsoft Support article How to configure SQL Server 2005 to allow remote connections

Related Topics

Named Pipe Connections