Steve Jones - SSC Editor
November 10, 2021 at 12:00 am
Comments posted to this topic are about the item SqlClient for .NET Protocols
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
November 12, 2021 at 2:39 am
In the Docs Client Protocols Properties (Order Tab), there is a note that the protocol order 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. This would mean that the correct answer is "You cannot change the order". The explanation given for QotD can be accepted because any protocol order settings for the .NET SqlClient from the user in SQL Server Configuration Manager may be possible, but will not be used. See the answers in this article "Why changing the order of network protocols does not make any sense?" or here "What is the default network protocol in SqlConnection class".
November 12, 2021 at 9:23 pm
Sorry, I responded to the first comment while too busy.
November 13, 2021 at 1:21 pm
Thanks Steve for your work. Yes, time seems to be running faster and faster, sometimes I have a hard time catching up ...: -
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply