Skip to content

All ports

Port 1433: Structured Query Language (SQL) Server / MSSQL

Port 1433 is used by Structured Query Language (SQL) Server and MSSQL over TCP. Port 1433 is the default TCP port of Microsoft SQL Server. It appears in the study tables for N10-009, SY0-701.

What runs on port 1433

Structured Query Language (SQL) Server uses TCP at the application layer. Default listener for Microsoft database engine connections.

MSSQL uses TCP at the application layer. Microsoft SQL Server database.

Port 1433 is the default TCP port of Microsoft SQL Server. Applications and management tools connect to it to run queries against a database instance.

Secure alternative and common mix-ups

The study tables do not list a separate secure replacement for Structured Query Language (SQL) Server or MSSQL. Where it has to cross a network you do not control, restrict who can reach it and carry it inside a VPN.

Database ports should be reachable only from the application servers that need them. An instance with 1433 open to the internet is routinely scanned and attacked, and named instances may listen on other ports found through a browser service.

Check port 1433 on your own network

To test a remote host from Windows, run Test-NetConnection with the host name and -Port 1433. From Linux or macOS, run nc -vz host 1433. To see what is listening on the machine itself, use ss -tulpn on Linux or netstat -ano on Windows and look for :1433.

A refused connection usually means no service is listening, and a probe that hangs usually means a firewall dropped it. Check the service, then the host firewall, then the network firewall, in that order.

Exam objectives that include it

These are the objectives whose tables list port 1433. The same row appears in the cheat sheet for each exam.

Learn 1433 together with these. They are its pair, its secure counterpart or a service that sits under the same objective.

Questions

The port number does not decide that. Structured Query Language (SQL) Server and MSSQL on port 1433 is only as safe as its configuration, how far it is exposed and how current the software is.

Keep going with the ports quiz and the cheat sheets.

Start studying free

Free plan, no card.