Required ports for SQL Server 2008 R2. Enable these ports in the Windows Firewall.
135 Transact SQL Debugger
1433 SQL Traffic
1434 SQL Browser Traffic
2383 SQL Analytics Traffic
4022– SQL Broker Traffic
Note: The SQL Server 2008 R2 installation doesn’t enable TCP/IP and Named Pipes Protocols by default, so it needs to be enabled in SQL Server Configuration Manager. This is located in Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager. After enabling the protocols, restart the SQL Server service. This will allow clients to connect to the SQL Server.
