Windows firewall which ports are opened for SQL Server named instance using dynamic port

by SqlWorldWide   Last Updated January 13, 2018 01:00 AM

In case of SQL Server named instances default configuration in to use TCP port which is dynamic and determined at the time the Database Engine starts.

The SQL Server Browser service listens for incoming connections to a named instance and provides the client the TCP port number that corresponds to that named instance.

I also understand a named instance can use a static port and in those case you can just open that port in your firewall.

What ports you open when using dynamic port for named instance and hosting multiple named instance in the same host?

Do you open the whole dynamic port range for TCP/UDP 49152–65535?

Related Questions

RDP port change config - no room for error

Updated April 17, 2017 12:00 PM

How can I find out if a port is opened or not?

Updated June 25, 2017 18:00 PM

Unlock port 2222 on Windows Server 2008 r2

Updated July 28, 2017 08:00 AM