When to use a TCP dynamic port and when TCP Port?

1 vote

2 answers

2673 views

sql-server security connectivity sql-server-2017 dynamic-ports

                          I have a new server that is configured using a dynamic port as you can see below:

The application that connects to this server uses the following connection string, but I am getting the following error:

I asked the developer to change the connection port from 61844 to 53187, which is my dynamic port.

After done that and restarting their services, the application could connect to SQL Server.

Is there any specific reason it needs to be using a dynamic port?

Asked by Marcello Miorelli (17274 rep)

Oct 15, 2018, 01:16 PM
Last activity: Apr 13, 2019, 04:39 PM

When to use a TCP dynamic port and when TCP Port?

Related Questions