If you have all 3 protocols enabled in SQL Server 2016, which protocols are prioritized on the server instance?

Couldn't find any specific documentation on this and don't really understand how it works that well.


If no protocol is specified , the connection will try based on the order. This is specified in the Enabling a Protocol section in Choosing a network protocol


From the Microsoft documentation:

Configure Client Protocols
Microsoft SQL Server supports client communication with the TCP/IP network protocol and the named pipes protocol. The shared memory protocol is also available if the client is connecting to an instance of the Database Engine on the same computer.

Choosing a Network Protocol
To connect to SQL Server Database Engine you must have a network protocol enabled. Microsoft SQL Server can service requests on several protocols at the same time. Clients connect to SQL Server with a single protocol. If the client program does not know which protocol SQL Server is listening on, configure the client to sequentially try multiple protocols. Use SQL Server Configuration Manager to enable, disable, and configure network protocols.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.