Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager)

This topic describes how to configure a server to listen on an alternate pipe in SQL Server 2012 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.

To configure the named pipe used by the SQL Server Database Engine

  1. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration, and then click expand Protocols for <instance name>.

  2. In the details pane, right-click Named Pipes, and then click Properties.

  3. On the Protocol tab, in the Pipe Name box, type the pipe you want the Database Engine to listen on, and then click OK.

  4. In the console pane, click SQL Server Services.

  5. In the details pane, right-click SQL Server (<instance name>) and then click 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.

To access SQL Server Configuration Manager Using Windows 8

Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager not does not appear as an application when running Windows 8. To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager11.msc (for SQL Server 2012) or SQLServerManager10.msc for (SQL Server 2008), and then press Enter.

Arrow icon used with Back to Top link [Top]

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.