Port 56731?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Programming » Connecting » Port 56731?

Add to briefcase

Port 56731?

Expand / Collapse

Author

Message

Posted Friday, February 01, 2013 10:39 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:30 PM
Points: 10, Visits: 112

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 01, 2013 11:29 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:33 PM
Points: 21,832, Visits: 27,860

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.

Cool

Cool

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 01, 2013 11:48 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:30 PM
Points: 10, Visits: 112

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 03, 2013 8:28 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:01 PM
Points: 2,489, Visits: 2,091

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 03, 2013 10:36 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:01 PM
Points: 2,489, Visits: 2,091

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 04, 2013 10:30 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:30 PM
Points: 10, Visits: 112

Excellent. Thank you all for the information.

Post #1415400

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse