In an Enterprise pool, if you install SQL Server 2008 on the computer that you designate as the back end and the Windows Server 2008 operating system is installed, you must configure the Windows Firewall to allow any computer that can identify itself as a member of either the Domain network or Private network to access SQL Server using Transmission Control Protocol (TCP) over port 1433. For details about ports to which SQL Server 2008 may require access, see Configuring the Windows Firewall to Allow SQL Server Access at http://go.microsoft.com/fwlink/?LinkId=131093 . For details about Network Location Profiles in Windows Server 2008, see Network Location Types at http://go.microsoft.com/fwlink/?LinkId=131211 .

Configure Windows Firewall on the Back-End Database Server

  1. Log on to the computer where you installed SQL Server for Office Communications Server 2007 R2.

  2. Click Start, click Administrative Tools, and then click Windows Firewall with Advanced Security.

  3. Right-click Inbound Rules, and then click New Rule.

  4. In the New Inbound Rule Wizarddialog box, on the Rule Typepage, click Port, and then click Next.

  5. On the Protocol and Portspage, click TCP, click Specific local ports, type 1433, and then click Next.

  6. On the Actionpage, click Allow the connection, and then click Next.

  7. On the Profilepage, do all of the following:

    • Select the Domaincheck box.

    • Select the Privatecheck box.

    • Clear the Publiccheck box.

  8. Click Next.

  9. On the Namepage, click Name, and then type a meaningful name for the new inbound rule.

  10. (Optional) Click Description (optional), and then type a description for the inbound rule.

  11. Click Finish.