All geek questions in one place

Server ports 445 and 1433

What is the difference between SQL Server 445 and 1433 and for each port destined for?

+4
source share
3 answers

445 is not an SQL port; it is an SMB port. It is only enabled in SQL Server if you use the named pipes protocol because named pipes exceed SMB, and this in turn uses 445 for SMB over IP ', aka. like SMB "NETBIOSless", unlike the old NetBIOS based SMB, which uses 137-139.

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

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

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

+11
source

445 is used for communication using named pipes over TCP (as described here ), 1433 is used for direct communication over TCP.

+1
source

Source: https://habr.com/ru/post/1304929/

More articles:


All Articles