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 needs to be changed for SQL Server when connected. I use this in my company when I connect to one of our server using named pipes instead of TCP/IP.

Image 1: Default Login

Image 2: Options

Image 3: Option Network Protocol Example

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

3 thoughts on “SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS

  1. Hello Sir ,

    You Solution is Fantastic Sir ……………

    I got many Solution of my Problem From this Sites .

    Thanks You Very Much

  2. 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.

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #050 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s