Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Client Protocols Properties (Order Tab)

Use the Order page on the Client Protocols Properties dialog box to view and enable the client protocols.

Click a protocol, and then click Enable or Disable to move the selected protocol to the Disabled Protocols or Enabled Protocols list.

Protocols are tried in the order listed, attempting to connect using the top protocol first, and then the second listed protocol, etc. Move protocols up or down the Enabled Protocols list, by clicking the up arrow and down arrow buttons. When connecting to Microsoft SQL Server from a client on that computer, the Shared Memory protocol will always be tried first, if enabled.

ms187884.note(en-US,SQL.90).gifNote:
These settings are not used by Microsoft .NET SqlClient. The protocol order for .NET SqlClient is first TCP, and then named pipes, which cannot be changed.

Disabled Protocols

Lists protocols which are installed but are not currently used.

Enabled Protocols

Lists protocols which are available for Microsoft SQL Server 2005 clients on this computer.

>

Enables the currently highlighted protocol in the Disabled Protocols box, moving it to the Enabled Protocols box.

<

Disables the currently highlighted protocol in the Enabled Protocols box, moving it to the Disabled Protocols box.

Up arrow

Moves the highlighted protocol up in the list. This allows you to increase the priority in which the Net-Library will attempt to use the selected protocol for connections.

Down arrow

Moves the highlighted protocol down in the list. This allows you to decrease the priority in which the Net-Library will attempt to use the selected protocol for connections.

Enable Shared Memory Protocol

Enables the shared memory protocol which is always tried first (if enabled), when connecting to SQL Server from a client on that computer.

ms187884.note(en-US,SQL.90).gifNote:
If the protocol is specified through a prefix or as part of the connection string, only the specified protocol is attempted.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.