Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
This article describes how to configure a server to listen on an alternate pipe in SQL Server by using SQL Server Configuration Manager. By default, the default instance of SQL Server Database Engine listens on named pipe \\.\pipe\sql\query. Named instances of SQL Server Database Engine and SQL Server Compact listen on other pipes.
There are three ways to connect to a specific named pipe with a client application:
Run the SQL Server Browser service on the server.
Create an alias on the client, specifying the named pipe.
Program the client to connect using a custom connection string.
Use SQL Server Configuration Manager
In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration, and then select expand Protocols for <instance name>.
In the details pane, right-click Named Pipes, and then select Properties.
On the Protocol tab, in the Pipe Name box, type the pipe you want the Database Engine to listen on, and then select OK.
In the console pane, select SQL Server Services.
In the details pane, right-click SQL Server (<instance name>) and then select Restart, to stop and restart SQL Server.
When SQL Server is listening on an alternate pipe, there are three ways to connect to a specific named pipe with a client application:
Run the SQL Server Browser service on the server.
Create an alias on the client, specifying the named pipe.
Program the client to connect using a custom connection string.