5

I understand that a SQL server named instance will default to dynamic ports, and I know HOW to change that to a static IP:

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

Paul
  • 2,755
  • 6
  • 24
  • 35
Dave
  • 357
  • 2
  • 6
  • 17

1 Answers1

7

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.

Also this is the default range.

To know the exact range you can use the following command on the server

NetSh INT IPV4 SHOW DynamicPort TCP.

This range can be changed to default using the following command

NetSh INT IPV4 SET DynamicPort TCP Start=49152 num=16384.

Reference : Default dynamic port range for TCP/IP has changed

pacey
  • 3,833
  • 1
  • 15
  • 31
Quick Joe Smith
  • 204
  • 1
  • 7
  • 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 02 '10 at 14:51
  • 1
    Quick Joe Smith is correct about the range, check out this [link](http://support.microsoft.com/kb/174904). – Jason Cumberland Jul 02 '10 at 18:19