SQL Server Performance Forum – Threads Archive
<default>Network Protocol in Connection PropertiesWhen I try to connect to a Database Engine in SSMS, there is an entry for Network Protocol in the Connection Properties tab. It has the value <default>. 1. Which Network Protocol will be used when the value is <default>?
2. Can I control which Network Protocol wil be used when the value is <default> and how? (note: this means I leave the value as <default>.) Will the answers for these 2 questions be different for a Named Instance and Default Instance? for a local instance and remote instance?
I believe Default protocol is the which is configured in SAC…by default it is TCP/IP, you can change it in the SAC to connect with different protocol… MohammedU.
It depends what you want to use as explained TCP/IP is industry standard and you can also use named-pipes as few providers are not compatible with TCP/IP, KBAhttp://support.microsoft.com/kb/914277 &http://blogs.msdn.com/sql_protocols/archive/2005/10/19/482840.aspx and if you planning to use any other services other than usual SQL Server then make sure to test them before putting them into production. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.