If shared memory, named pipes, TCP/IP network protocols are all enabled which has priority? 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