Home / server / Questions / 157005
Accepted
Dave
Asked: 2010-07-03 06:27:44 +0800 CST

MS SQL Server Dynamic Port Range

  • 772

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?

sql-server port dynamic

1 Answers

  1. Best Answer

    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

    • 7