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

SQL Server Port Number Assignments - How To Determine What Number To Use Expand / Collapse
Author
Message
Posted Monday, April 15, 2013 1:57 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 889, Visits: 1,550
Google "SQL Server Static Ports" or any variation of it and you'll get a hundreads of thousands or more pages full of links and everyone will provind emost of what you need.

If you query is instead "How to Determine WHAT Port Number TO use" then forget about it, you get nothing.

I've found more articles then I can count on how to change SQL Server from dynamic port to fixed ports but not one on how to determine what port number to assign. I know there are lists of port numbers used by certain apps and services but that still doesn;t help me to deterine what poirt numbers I can or even should use for SQL Server. Do I just randomly piece together a set of 6 dgits or do I need to select from a specifi range and if yes what range and how do I detemrine if a port number is OK to use?

Perhaps this ia dumb question that everyone knows but me and thats why theres no hits for this query?

We're setting up Syetm Center 2012 and we have no choice but to go with Static ports. Does anyone have any suggestions on how I go about dertermining what post number(s) I can use/try?


Thanks


Kindest Regards,

Just say No to Facebook!
Post #1442485
Posted Monday, April 15, 2013 2:09 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 1:23 PM
Points: 23,398, Visits: 32,252
The best I can provide is based on when I was setting up database mirroring. First, iirc, you need to select a port number above 1024, and I thought under 32768. When selecting this port number, work with your network services personnel to help identify an open port or range of open ports you can use such that they can document the port number(s) such that future applicatioins don't suddenly take the port(s) you and Network Services assigned.



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 #1442490
Posted Monday, April 15, 2013 2:28 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 889, Visits: 1,550
Lynn Pettis (4/15/2013)
The best I can provide is based on when I was setting up database mirroring. First, iirc, you need to select a port number above 1024, and I thought under 32768. When selecting this port number, work with your network services personnel to help identify an open port or range of open ports you can use such that they can document the port number(s) such that future applicatioins don't suddenly take the port(s) you and Network Services assigned.


Lynn,

It sound like the answer is (at least for me) ask your network admin for one or more ports you can use. That would explain why theres no SQL Server spefici hitys on what port number to use but still, it sure would be nioce it at least the Microsoft hosted items said something along the lines of..

"Unsure of what port number to use when assigning a fixed port to SQL Server? Check with your network admin for a range of valid port numbers to use with the SQL Server instances in your domain". Anything that would let the readr know that POrt Number selection is something that typically is handled by someone else.

Thanks Lynn


Kindest Regards,

Just say No to Facebook!
Post #1442494
Posted Monday, April 15, 2013 2:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:30 PM
Points: 12,918, Visits: 32,089
just a suggestion, but in the past i've used port 14330 (1433 x 10)
and also on my current dev machine, that has every version as an instance,
they use ports 12005 for SQL 2005, 12008 for SQL 2008 (my R2 is the defailt instance) and 12012 for my SQL 2012.

just saying, it made sense at the time.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1442497
Posted Monday, April 15, 2013 3:10 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 6,365, Visits: 13,695
In the folder

C:\Windows\System32\Drivers\etc

You'll find the HOSTS file here and also one titled SERVICES. Open the SERVICES file and it contains details of ports already assigned to services on the sever. Pick a port value not in use to ensure you have no service clashes.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1442505
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse