What is SQL Server default port?

The default port of SQL server is 1433. But it’s only for the default instances. If it’s a named instance, you get a random number.

You can also find the port by sunning this query:

SELECT
	local_tcp_port
FROM
	sys.dm_exec_connections
WHERE
	local_tcp_port IS NOT NULL;

SQL Server Browser service port is UDP 1434.

SQL Reporting services port is 80. If SSL is enabled then it’s 443.

SQL Server Analysis services default port is 2383 but just like SQL Server, only default instances use that, the named instances get a random number.

---

Need a good GUI tool for databases? TablePlus provides a native client that allows you to access and manage MySQL, SQL Server, PostgreSQL and many other databases simultaneously using an intuitive and powerful graphical interface.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

Need a quick edit on the go? Download for iOS