Port / TCP
1433Microsoft SQL Server
The default listener for Microsoft SQL Server database engine instances.
If it is internet-facing: Finding 1433 open to the internet is a finding in its own right — it warrants an explanation, not just a rule.
Exposure
Trusted network only
Transport
Encryption optional
Risk if public
High
Exposure verdict
Port 1433 belongs on a trusted internal network. If a perimeter scan finds it answering, treat that as a firewall defect rather than a configuration preference.
Encryption is available but negotiated or configured rather than guaranteed. A client that does not insist on it will silently fall back to plaintext.
Registered with IANA on request, but bindable by any unprivileged user. Registration records intent — it does not reserve the port, so collisions between products are common.
Grouped with the other databases & caches ports so a rule written for one can be checked against its neighbours.
What actually goes wrong
2 notes- Exposed SQL Server is subject to constant credential attacks against the sa account.
- If xp_cmdshell is enabled, a database compromise is a host compromise.
Recommended firewall rule
Allow only from 10.0.0.0/8, drop the rest
Swap in the CIDR your administrators or application tier actually come from — the point is that the default answer is no.
ufw
sudo ufw allow from 10.0.0.0/8 to any port 1433 proto tcpiptables
sudo iptables -A INPUT -p tcp -s 10.0.0.0/8 --dport 1433 -j ACCEPT
sudo iptables -A INPUT -p tcp --dport 1433 -j DROPIf you do need it open to everyone
sudo ufw allow 1433/tcpWrite down why. An unexplained allow rule outlives the person who added it, and the next reviewer has no way to tell a deliberate exception from an accident.
Check what is really there
Listening locally
sudo ss -tlpn 'sport = :1433'The bind address is the answer that matters: 127.0.0.1 is local-only, 0.0.0.0 and :: mean every interface.
Listening (macOS)
sudo lsof -nP -iTCP:1433 -sTCP:LISTENmacOS ships lsof rather than ss; this names the owning process and user.
From outside
nmap -sV -Pn -p 1433 <host>A version probe confirms whether Microsoft SQL Server is actually what answers, rather than trusting the number. Only scan hosts you are authorised to test.
Reachability
nc -vz <host> 1433The quick yes/no when you only need to know whether a path exists through the firewall.
The safer path
no port changeChange the configuration, not the port
Reach it through a VPN or a bastion; databases have no business on a public interface.
The fix here lives in the service configuration rather than in a different port assignment.