Port 1433 – Microsoft SQL Server Protocol Specification

Technical analysis, security advisories, vulnerability mitigation, and firewall syntax for TCP/UDP port 1433 (Microsoft SQL Server).

Port Number 1433

Transport Protocol TCP

Port Range Type Registered (1024-49151)

Default Status Restricted / LAN

Service Description & Architectural Context

Default listener port for Microsoft SQL Server relational database.

IANA / RFC Designation:

Port 1433 is assigned to Microsoft SQL Server under the Internet Assigned Numbers Authority (IANA) service name registry. In enterprise infrastructure and homelab setups, services listening on this port must follow the principle of least privilege.

Security Analysis & Attack Surface Assessment

Do not expose to the internet. Bind to local loopback or private subnet.

Hardening Recommendations:

Do not expose port 1433 to public WAN interfaces unless authenticated TLS or VPN wrapping is strictly enforced.
Enforce rate-limiting using Fail2ban, CrowdSec, or cloud edge DDoS protection.
Audit active listening sockets locally: ss -tulpn | grep :1433 or netstat -ano | findstr :1433.

Firewall Rule Snippets for Port 1433

UFW (Ubuntu / Debian Linux)

sudo ufw allow 1433/tcp

iptables (Standard Linux Kernel)

sudo iptables -A INPUT -p tcp --dport 1433 -j ACCEPT

Windows PowerShell (Defender Advanced Firewall)

New-NetFirewallRule -DisplayName "Allow Port 1433" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow

Quick Port Jump

Common Sysadmin Ports

Port 22 SSH Port 80 HTTP Port 443 HTTPS Port 3306 MySQL Port 5432 PgSQL Port 6379 Redis