This was a very old blog post and I have decided to re-write this as it was no longer useful. In this blog post, we will learn about SQL Server 2017. Here is how you can download SQL Server 2017 related material.
Following images quickly explain how to connect to SQL Server with different connection property. It can be useful when connection properties need to be changed for SQL Server when connected. I use this in my company when I connect to one of our servers using named pipes instead of TCP/IP. Let us learn about Connection Property of SQL Server Management Studio SSMS.