Open firewall ports as listed in http://msdn.microsoft.com/en-us/library/cc646023.aspx
- 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)
- Programs
-
- SQL Server Management Studio
- SQL Server TCP-IN
- SQL Browser
- Visual Studio Remote Debugging