Solved

SQL Server 2005 Min/max port value

Posted on 2007-11-26
2
793 Views
Last Modified: 2013-11-06
What is the range of port values on SQL Server 2005?

Thanks
0
Comment
Question by:gromul
  • 2
2 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
Comment Utility
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
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
Glad I could be of any help !
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now