SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS

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.

Image 1: Default Login
SQL SERVER - 2005 - Connection Property of SQL Server Management Studio SSMS connection1

Image 2: Options
SQL SERVER - 2005 - Connection Property of SQL Server Management Studio SSMS connection2

Image 3: Option Network Protocol Example
SQL SERVER - 2005 - Connection Property of SQL Server Management Studio SSMS connection3

Here are few additional blog posts which are very relevant to this blog post and will be interesting reading.

SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
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.

SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio
Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer does not have access to it. It is very easy to clean the list and start over.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQLAuthority News – Latest Interesting Downloads and Articles
Next Post
SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE

Related Posts

3 Comments. Leave new

  • Hello Sir ,

    You Solution is Fantastic Sir ……………

    I got many Solution of my Problem From this Sites .

    Thanks You Very Much

    Reply
  • Anton Liebscher
    April 26, 2011 10:07 pm

    Good Afternoon,

    can you tell me where SQL stores the information from previous logins? I would like to edit/remove old/redundant connections that clutter my drop-downs.

    Many Thanks

    Anton Liebscher

    Your site is much appreciated and has solved a number of problems for me. Many Thanks.

    Reply

Leave a Reply

Menu