October 8, 2007 by pinaldave
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)
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2000 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of three SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Hello Sir ,
You Solution is Fantastic Sir ……………
I got many Solution of my Problem From this Sites .
Thanks You Very Much
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.