up vote 2 down vote favorite
share [g+] share [fb]

I understand that a SQL server named instance will default to dynamic ports, and I know HOW to change that to a static IP: http://blogs.msdn.com/b/sqlserverfaq/archive/2008/06/02/how-to-change-the-dynamic-port-of-the-sql-server-named-instance-to-an-static-port-in-a-sql-server-2005-cluster.aspx

BUT, I'm still wondering what that dynamic range will be?

link|improve this question
100% accept rate
feedback

2 Answers

up vote 2 down vote accepted

It's not a range as such. It uses 1433 by default.

If you're referring to the dynamic port range for TCP/UDP, it is 49152–65535. Refer to wikipedia's list of TCP/UDP ports for more info. I don't know if this is of any relevance to your question though.

link|improve this answer
A single default instance will use 1433, but clustered or named instances use the sql browsing service to arbitrate the port number to clients, but I need to know what port range that could in order to open them on the internal firewall. – Dave Jul 2 '10 at 14:51
feedback
up vote 0 down vote

Quick Joe Smith is correct about the range, check out this link.

link|improve this answer
Thanks Jason, agreed. – Dave Jul 2 '10 at 19:51
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.