What ports are required for SQL Server?

Question

Which ports need to be opened in a firewall to access SQL server? Port 1433 for TCP is needed to connect to the SQL database instance. By default, SQL will attempt to use 1433. . Port 1434 for UDP is needed to allow the automatic discovery of SQL by the workstations.

What ports do SQL Server use?

By default, the typical ports used by SQL Server and associated database engine services are: TCP 1433, 4022, 135, 1434, UDP 1434. The table below explains these ports in greater detail. A named instance uses dynamic ports.

Is SQL 1433 UDP or TCP?

TCP port 1433 is the default port for SQL Server. This SQL port is also the official Internet Assigned Number Authority (IANA) socket number for SQL Server.

Does SQL Server use port 445?

445 is not a SQL port, is a SMB port. It is involved in SQL Server only if you use named pipes protocol, as named pipes are over SMB and this in turn uses 445 for 'SMB over IP', aka. as SMB 'NETBIOSless' as opposed to the old NetBIOS based SMB, which uses 137-139.

What is the difference between port 1433 and 1434?

The default instance of SQL Server listens on Port 1433. Port 1434 is used by the SQL Browser Service which allows connections to named instances of SQL Server that use dynamic ports with out having to know what port each named instance is using, especially since this can change between restarts of the named instance.

Expert · Answer