Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Port 56731? Expand / Collapse
Author
Message
Posted Friday, February 1, 2013 10:39 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:47 PM
Points: 10, Visits: 159
We were having an issue where SSMS was unable to connect to a named instance of SQL Server 2008 R2. We had TCP 1433 and UDP 1434 open.

We allowed all traffic to see what else it was trying to use and found port TCP 56731. When we opened that port it worked... I have never seen this port related to SQL before.

Any clues?
Post #1414762
Posted Friday, February 1, 2013 11:29 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:54 PM
Points: 23,240, Visits: 31,936
Named instances use dynamically assigned ports. The browser service normally handles this behind the scenes but the port(s) used still need to be open.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1414775
Posted Friday, February 1, 2013 11:48 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:47 PM
Points: 10, Visits: 159
Thanks for the info!

Is there a range that I can open or do I always need to check what is assigned?


*Note to other readers you can see the port used here:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.<InstanceName>\MSSQLServer\
SuperSocketNetLib\TCP\IPAll\
Post #1414786
Posted Sunday, February 3, 2013 8:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:24 PM
Points: 2,954, Visits: 2,557
By default, SQL Server uses dynamically assigned port numbers. You have the option to assign a specific port number to an instance of SQL Server.

You can do this using the "SQL Server Configuration Manager". Have a look in Books Online for the topic "How to: Configure a Server to Listen on a Specific TCP Port" - it gives you all the details you will need to do this



Post #1415089
Posted Sunday, February 3, 2013 10:36 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:24 PM
Points: 2,954, Visits: 2,557
The port number is also available in the SQL Server log - it is one of the messages logged when SQL Server starts.


Post #1415105
Posted Monday, February 4, 2013 10:30 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:47 PM
Points: 10, Visits: 159
Excellent. Thank you all for the information.
Post #1415400
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse