sql server port 1433 vs 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.

1434是给UDP使用的。UDP是和TCP同层的网络协议。但和TCP不同的是，UDP没有握手，而是类似广播，不需要得到对方的回应。这也是UDP被用于SQL Brower Service的原因。