Thursday, September 18, 2014

Ports and Protocols Used by Microsoft SQL Server

Service / PurposeProtocolPort
Analysis Services connections via HTTP (default)TCP80
Analysis Services connections via HTTPS (default)TCP443
ClusteringTCP135 (RPC) / 3343 (Cluster Network Driver) / 445 SMB / 139 NetBIOS / 5000-5099 (RPC) / 8011-8031 (RPC)
Database MirroringTCPThere is no default port for this service. Use the following T-SQL statements to identify which ports are in use: SELECT name, port FROM sys.tcp_endpoints.
Dedicated Administrator ConnectionTCP1434 by default (local port). But this port is assigned dynamically by SQL Server during startup.
FilestreamTCP139 y 445.
Microsoft Distributed Transaction Coordinator (MS DTC)TCP135
Reporting services Web ServicesTCP80
Reporting Services configured for use through HTTPSTCP1433
Service BrokerTCP4022
SQL Server 2008 Analysis ServicesTCP2382 (SQL Server Browser Services for SSAS port)
2383 (Clusters will listen only on this port)
SQL Server Browser Service (Database Engine)UDP1434. Might be required when using named instances.
SQL Server Browser ServiceTCP2382
SQL Server default instance running over an HTTPS endpoint.TCP443
SQL Server Instance (Database Engine) running over an HTTP endpoint.TCP80 y 443 (SSL).
SQL Server Integration ServicesTCP135 (DCOM).
SQL over TCP (default instance)TCP1433
Transact-SQL DebuggerTCP135
Windows Management InstrumentationTCP135 (DCOM)


Configuring the Windows Firewall to Allow SQL Server Access. 

Enable a network for cluster use.

No comments:

Post a Comment