What is the protocol and port necessary for a Microsoft SQL Server database connection?

What ports are required for SQL Server?

Ports Used By the Database Engine. By default, the typical ports used by SQL Server and associated database engine services are: TCP 1433, 4022, 135, 1434, UDP 1434.

What protocol is used to connect SQL Server?

The most commonly used network protocol in SQL Server is the TCP/IP protocol. This protocol connects computers with different hardware and operating systems specs and allows it to communicate together, as it includes network traffic routing standards with advanced security protection.

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.

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.