Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Specifying Port Number in SSMS while Connecting to Remote SQL Server

May 31 2012 12:00AM by Dattatrey Sindol (Datta)   

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 dialog box. To address this, you can specify the Server Name as "<<ServerName>>,<<PortNumber>>" instead of just "<<ServerNumber>>".

[Updated : 2012-06-04]: SQL Browser Service was running while connecting (Updated for more clarify based on comment from Sachin)

Read More..   [61 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Dattatrey Sindol (Datta)
42 · 4% · 1336
13
 
4
 
10
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

9  Comments  

  • 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 would suffice.

    commented on Jun 1 2012 9:50AM
    Dattatrey Sindol (Datta)
    42 · 4% · 1336
  • True, in most cases, specifying the server name is sufficient in most cases. However, we had a requirement wherein the IT guys at a customer location only believed in IP addresses. Although this happened a couple of years ago, I thought of sharing it with all.

    commented on Jun 1 2012 11:09AM
    Nakul Vachhrajani
    4 · 36% · 11616
  • 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 satisfaction. Appreciate your sharing!!

    commented on Jun 1 2012 11:20AM
    Dattatrey Sindol (Datta)
    42 · 4% · 1336
  • Did you check whether the SQL Browser is running ? Cause all the incoming connections to the named instance would be invalidated if sql browser is not running for the instance or you have not mentioned the port number or the named pipe in the connection parameter.

    commented on Jun 2 2012 1:15PM
    Sachin Nandanwar
    498 · 0% · 76
  • @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).

    commented on Jun 3 2012 11:30AM
    Dattatrey Sindol (Datta)
    42 · 4% · 1336
  • @Sachin: I have seen a couple of production instances where SQL Server browser service is either disabled or they have chosen to hide the instances from an enumeration request due to security reasons. You can refer my post: http://beyondrelational.com/modules/2/blogs/77/posts/11347/sql-server-configuration-manager-hide-your-sql-server-instance.aspx for more details. In most production instances, we don't rely on the SQL server browser service.

    commented on Jun 3 2012 11:33AM
    Nakul Vachhrajani
    4 · 36% · 11616
  • @Datta Unfortunately I couldn't find anywhere in your article where you had mentioned that browser was running hence the question.

    commented on Jun 3 2012 2:03PM
    Sachin Nandanwar
    498 · 0% · 76
  • @Sachin - Thanks for pointing out. I have updated the above tip as well as the original article to include the additional information about SQL Browser Service.

    commented on Jun 4 2012 12:17PM
    Dattatrey Sindol (Datta)
    42 · 4% · 1336

Your Comment


Sign Up or Login to post a comment.

"Specifying Port Number in SSMS while Connecting to Remote SQL Server" rated 5 out of 5 by 13 readers
Specifying Port Number in SSMS while Connecting to Remote SQL Server , 5.0 out of 5 based on 13 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]