Step 15 - Enable SQL Firewall Ports

Applies To: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012

This step explains how to enable the firewall rules on the new SQL server. These rules are required to allow the AD RMS cluster to communicate with the SQL Server.

To enable the firewall ports on SQL2

1. Log on to SQL2.fabrikam.com as fabrikam\Administrator.

2. Click Start, select Administrative Tools and click Windows Firewall with Advanced Security. This will bring up Windows Firewall with Advanced Security.

   

3. On the left, select Inbound Rules and on the right click New Rule. This will bring up the New Inbound Rule Wizard.

   

4. On the Rule Type screen, select Port and click Next.

   

5. On the Protocol and ports screen, select TCP and enter 445 in the box next to Specific local ports: and click Next.

6. On the Action screen, select Allow the connection and click Next.

   

7. On the Profile screen, select Domain, Private, and Public then click Next.

   

8. On the Name screen, enter SQL Server Named Pipes in the box and click Finish.

9. Repeat these steps for all of the entries in the table below.

Table 8 – SQL Server Firewall Port Exceptions