Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

sql server ports 445 and 1433

What is the difference between sql server ports 445 and 1433 and what is each port intended for?

like image 855
oren Avatar asked Mar 23 '10 20:03

oren


People also ask

Does SQL Server use port 445?

The SQL Server connection to a server configured for accepting Named Pipes and TCP/IP connections is using RPC (port 445) instead of port 1433, by TCP/IP.

What port is 445 used for?

Port 445 is a traditional Microsoft networking port with tie-ins to the original NetBIOS service found in earlier versions of Windows OSes. Today, port 445 is used by Microsoft Directory Services for Active Directory (AD) and for the Server Message Block (SMB) protocol over TCP/IP.

What is 1433 port used for?

Port 1433 for TCP is needed to connect to the SQL database instance. By default, SQL will attempt to use 1433. If that port is unavailable, it will automatically choose another port.

Is port 1433 inbound or outbound?

Inbound traffic on TCP Port 1433 needs to be allowed on the SQL server. Connect to your SQL server.


1 Answers

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.

1433 is the SQL Server TCP listener port when SQL Server uses directly TCP.

To configure the server to listen on specific protocols, use SQL Server configuration Manager. To configure the client allowed protocols, see Configuring Client Network Protocols.

It is better to disable Net Pipes and rely solely on TCP (1433), for reasons of performance and easy of deployment/configuration.

like image 196
Remus Rusanu Avatar answered Oct 02 '22 07:10

Remus Rusanu