Purpose

The purpose of this article is to teach you the process of aliasing a client to an alternate pipe in Microsoft SQL Server 2000.

To Alias a Client to an Alternate Pipe

Named Pipes clients usually connect using the server instance name on the default pipe. However, if a server is set up to listen on an alternate pipe, the client must also be configured to communicate to that pipe.

Following steps describe you the step by step details of aliasing a client to an alternate pipe:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Client Network Utility.

2. Select Alias tab.

3. Click Add button.

4. Enter an alias for Server alias, and replace sqlquery with a new pipe name for Pipe name. i.e. altpipe, and click OK. 

5. Click Apply, and then click OK.