Share via

Configure Windows Firewall for SQL Server 2008 Access

Topic Last Modified: 2009-07-20

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 For details about Network Location Profiles in Windows Server 2008, see Network Location Types at

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 Wizard dialog box, on the Rule Type page, click Port, and then click Next.

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

  6. On the Action page, click Allow the connection, and then click Next.

  7. On the Profile page, do all of the following:

    • Select the Domain check box.
    • Select the Private check box.
    • Clear the Public check box.
  8. Click Next.

  9. On the Name page, 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.