1

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?

SqlWorldWide
  • 111
  • 4
  • 1
    https://technet.microsoft.com/en-us/library/ms175043(v=sql.110).aspx – joeqwerty Jan 13 '18 at 00:33
  • That will only work when you one named instance in one host. What about multiple named instance in same host? – SqlWorldWide Jan 13 '18 at 00:38
  • From the article: In the Program dialog box, select This program path. Click Browse, and **navigate to the instance of SQL Server that you want to access through the firewall**, and then click Open. – joeqwerty Jan 13 '18 at 00:42
  • Different version of SQL server will have different path. So can I create separate rules for each named instance? – SqlWorldWide Jan 13 '18 at 02:02
  • 1
    That's my take from the article. Each named instance of SQL Server will have a different path, so you could create a rule for each instance path. – joeqwerty Jan 13 '18 at 02:07

0 Answers0