SQL Server 2005 Min/max port value

What is the range of port values on SQL Server 2005?

Thanks
gromulAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
YveauConnect With a Mentor Commented:
default is 1433/1434 as you might know.
Next to that it is very unwise to use ports < 10000 ... that is what my network guys told me.
The risk is pretty high that you will use a port that is given to some kind of app by the IEEE (like SQL has 1433/1434). There should be a list on the Internet somewhere ...

So the advise of my network guys was to use a number as high as possible but < 65536 (2^16) because that is the limit of TCP/IP port numbers. I use 51433/51434 as default for second instances installed on a machine.

Hope this helps ...
0
 
YveauCommented:
Glad I could be of any help !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.