@Sachin - Thanks for pointing out. I have updated the above tip as well as the [original article][1] to include the additional information about SQL Browser Service. [1]: http://dattatreysindol.com/2012/05/28/ssms-specify-port-number-while-connec...

@Sachin - Yes the browser was running. But as mentioned in the original article, this approach didn't work for me with a Named Instance (with SQL Browser running)....

@Sachin - Yes the browser was running. But as mentioned in the original article, this approach didn't work for me with a Named Instance (with SQL Browser running)....

Sharing definitely makes a lot of sense. As a matter of fact we learn a lot of new things everyday from this wonderful community, and it's our duty to give back to this community and in fact contributing to the community is a pleasure and gives us satis...

Sharing definitely makes a lot of sense. As a matter of fact we learn a lot of new things everyday from this wonderful community, and it's our duty to give back to this community and in fact contributing to the community is a pleasure and gives us satis...

Thanks Nakul for posting the link. I just went through the link which you provided and I see that, in your approach we need to find out the IP address and provide that while connecting, which in most cases is not required as just providing Server Name w...

Thanks Nakul for posting the link. I just went through the link which you provided and I see that, in your approach we need to find out the IP address and provide that while connecting, which in most cases is not required as just providing Server Name w...

Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...

Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...

Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...