Windows 2019
Sponsored Link

SQL Server 2019 : Firewall Settings2020/01/30

 
It needs to configure Firewall if it is running and also if you'd like to connect to SQL Server from remote Hosts.
Service Protocol Port Description
Default Instance TCP 1433 Default Port for Default Instance
Default Instance (only for Admin) TCP 1434 Admin Port for Default Instance
SQL Server Browser Service UDP 1434 Used by SQL Server Browser if Named Instance is used
HTTP Connection TCP 80 HTTP Connection Port
(Database Engine, Analysis Services, Reporting Services)
HTTPS Connection TCP 443 HTTPS Connection Port
(Database Engine, Analysis Services, Reporting Services)
Service Broker TCP 4022 Not the default port but used in Books Online examples
Database Mirroring TCP 7022 Not the default port but used for Database Mirroring by Default Instance
Transact-SQL Debugger TCP 135 Transact-SQL Debug Port
Analysis Services TCP 2383 Default Port used by Default Instance
SQL Server Browser Service TCP 2382 Used by Named Instance for Analysis Services
Integration Services TCP 135 Integration Services use DCOM on Port 135

Matched Content