77 votes
Accepted

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. Which was asinine then and still asinine now. Security through ...
Sean Gallardy's user avatar
13 votes

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

Even though security through obscurity isn't actual security I won't say there aren't any cases where it helps. If an attacker wants to know where your service is listening they can easily find out, ...
Tom V's user avatar
  • 15.7k
9 votes

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 No, it wasn't. Some misguided people may have presented it as ...
Tom's user avatar
  • 91
6 votes

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

YES, it is still useful. Changing default ports has one real purpose only: defend against automated scans/attacks, if you database server is open towards hosts which might get compromised. While ...
Matija Nalis's user avatar
5 votes
Accepted

Does UDP Port 1434 need to be open for named instances with static TCP?

UDP 1434 is used for Named SQL Server instances and SQL Browser service listens on this port for any incoming requests to a named sql server instance. The browser service will respond to the client ...
Kin Shah's user avatar
  • 62.2k
2 votes

Does UDP Port 1434 need to be open for named instances with static TCP?

If the port is static (which it appears to be), you can simply connect to port 50101 using tcp:<ip address of sql server/NAT/firewall>,50101 in your connection string. For example: tcp:192.168....
Hannah Vernon's user avatar
  • 70.1k
2 votes
Accepted

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

Say that something else uses the port that you have configured for your SQL Server: What do you prefer? The SQL Server to start but use a different port? Use dynamic. Not start at all? Use static. ...
Tibor Karaszi's user avatar
1 vote

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

I would not change the port, but however never expose the database service directly over the internet. Only through a secure tunnel like SSH. Changing the port of SSH might be a good idea to minimize ...
Thomas's user avatar
  • 111
1 vote

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

Is there any specific reason it needs to be using a dynamic port? There is no good reason to continue using a dynamic port. They are used by default for named instances because there is no well-...
David Browne - Microsoft's user avatar
1 vote
Accepted

in what situations the dynamic port number in sql server is used?

Dynamic ports are used when a SQL Server instance is configured to use dynamic ports on the specified interface(s). By default, only named instances use dynamic ports as described in the documentation....
Dan Guzman's user avatar
  • 28.2k
1 vote

Does UDP Port 1434 need to be open for named instances with static TCP?

sql service check use ssms change sql logon mmode do mix mode use ssms tcp enable
user170244's user avatar
1 vote

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

another way to find which port sql server is using is through the DMV called sys.dm_exec_connections as per the script below. --=============================== -- sys.dm_exec_connections --===========...
Marcello Miorelli's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible