Firewall ports to open for SQL Server 2008
SQL Admin Connection- 1434 (TCP)
SQL Debugger - 135 (TCP)
SQL Service Broker - 4022 (TCP)
SQL TCP Browser - 2382 (TCP)
SQL UDP Browser - 1434 (UDP)
SQL Server - 1433 (TCP) Note: This may have to be open on the client side as well
SQL Dynamic Port - 49172 (TCP)
SQL Admin Connection- 1434 (TCP)
SQL Debugger - 135 (TCP)
SQL Service Broker - 4022 (TCP)
SQL TCP Browser - 2382 (TCP)
SQL UDP Browser - 1434 (UDP)
SQL Server - 1433 (TCP) Note: This may have to be open on the client side as well
SQL Dynamic Port - 49172 (TCP)
Client
ports are assigned a random value between 1024 and 5000
SELECT DISTINCT
local_tcp_port
FROM sys.dm_exec_connections
WHERE local_tcp_port IS NOT NULL
No comments:
Post a Comment