Questions tagged [dynamic-ports]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
24 votes
1 answer
38k views

When is a Dynamic Port "dynamic"?

I was having a discussion today about Dynamic Ports with one of my co-workers and could use some help clarifying how they work. First question: If the IPALL TCP Dynmaic Ports setting is a specific ...
Kenneth Fisher's user avatar
23 votes
5 answers
15k views

Is it still best practice to avoid using the default ports for SQL Server?

Historically, it has been recommended not to use the default ports for connections to SQL Server, as part of security best practice. On a server with a single, default instance, the following ports ...
user3399498's user avatar
4 votes
3 answers
3k views

TSQL to find if server is listening on dynamic or static port

Using TSQL, how can I find if the MS SQL server (any version) is configured to use static port or is it using dynamic port? Script i am trying to use: DECLARE @TcpPort VARCHAR(5) ,@RegKey ...
Manjot's user avatar
  • 1,203