Port reference › Databases
Port 1433 · MS SQL Server
Microsoft SQL Server
TCP Databases Exposure risk: High
What is port 1433 used for?
Default instance port for Microsoft SQL Server. Named instances are discovered through UDP 1434 (SQL Browser).
Registered port (1024-49151): the range used by ordinary applications.
Security notes
The sa account is a constant brute-force target. Block from outside and disable sa.
Allow port 1433 through the firewall
This port is risky to expose, so the commands below allow only the IPs you specify.
# Replace 203.0.113.10/32 with the IP or network you want to allow
sudo ufw allow from 203.0.113.10/32 to any port 1433 proto tcp
sudo ufw status # Replace 203.0.113.10/32 with the IP or network you want to allow
sudo firewall-cmd --permanent --add-rich-rule='rule family="ipv4" source address="203.0.113.10/32" port port="1433" protocol="tcp" accept'
sudo firewall-cmd --reload # Replace 203.0.113.10/32 with the IP or network you want to allow
sudo iptables -A INPUT -p tcp -s 203.0.113.10/32 --dport 1433 -j ACCEPT # Replace 203.0.113.10/32 with the IP or network you want to allow
New-NetFirewallRule -DisplayName "Allow TCP 1433" -Direction Inbound -Protocol TCP -LocalPort 1433 -RemoteAddress 203.0.113.10/32 -Action Allow # Replace sg-0123456789abcdef0 with your security group ID
aws ec2 authorize-security-group-ingress --group-id sg-0123456789abcdef0 --protocol tcp --port 1433 --cidr 203.0.113.10/32 Check whether port 1433 is open
sudo ss -tlpn | grep ':1433 ' netstat -ano | findstr :1433 nc -zv SERVER 1433
# Windows
Test-NetConnection SERVER -Port 1433 sudo lsof -i :1433