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.
Add a comment
|
2 Answers
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
answered Nov 30, 2016 at 16:13
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.
answered Nov 30, 2016 at 16:15
