| title | Client Protocols Properties (Order Tab) | |
|---|---|---|
| description | Discover how to enable or disable client protocols. See how to rearrange the order in which protocols are used when clients try to connect to SQL Server. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 06/05/2025 | |
| ms.service | sql | |
| ms.subservice | tools-other | |
| ms.topic | conceptual | |
| ms.collection |
|
|
| helpviewer_keywords |
|
|
| monikerRange | >=sql-server-2016 |
[!INCLUDE SQL Server Windows Only]
Use the Order page on the Client Protocols Properties dialog box in SQL Server Configuration Manager to view and enable the client protocols.
Select a protocol, and then select 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 selecting the up arrow and down arrow buttons. When connecting to [!INCLUDE ssNoVersion] from a client on that computer, the Shared Memory protocol is always tried first, if enabled.
Note
These settings aren't used by [!INCLUDE msCoName] .NET SqlClient. The protocol order for .NET SqlClient is first TCP, and then named pipes, which can't be changed.
Lists the protocols that are installed but aren't currently used.
Lists the protocols that are available for [!INCLUDE ssNoVersion] 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.
Moves up the highlighted protocol in the list. This option allows you to increase the priority in which the network library attempts to use the selected protocol for connections.
Moves down the highlighted protocol in the list. This option allows you to decrease the priority in which the network library attempts to use the selected protocol for connections.
Enables the shared memory protocol which is always tried first (if enabled), when connecting to [!INCLUDE ssNoVersion] from a client on that computer.
If the protocol is specified through a prefix or as part of the connection string, only the specified protocol is attempted.