Configure Windows Firewall for access to SQL Server 2008 on Windows Server 2008

Now more and more Windows Server 2008 servers, 2008 of the firewall than 2003 has a great increase in security has increased.

Even the outbound of port 80 is turned off by default. So if you need access outside of an application deployed on 2008Server, you need to add the ports you use on outbound, inbound rules, or if Windows Firewall is turned on, it is likely that the application will not be accessible externally.

Take SQL Server 2008 (default port 1433) as an example:

1. Log on to the computer that has SQL Server installed.

2. Click "Start", "Administrative Tools", "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 Ports, and then click Next.

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

6. On the Operations page, click Allow Connections, 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.

Configure Windows Firewall for access to SQL Server 2008 on Windows Server 2008