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
Log on to SQL2.fabrikam.com as Administrator.
Click Start, select Administrative Tools and click Windows Firewall with Advanced Security. This will bring up the Windows Firewall with Advanced Security mcc.
On the left, select Inbound Rules and on the right click New Rule. This will bring up the New Inbound Rule Wizard.
On the Rule Type screen, select Port and click Next.
On the Protocol and ports screen, select TCP and enter 445 in the box next to Specific local ports: and click Next.
On the Action screen, select Allow the connection and click Next.
On the Profile screen, select Domain, Private, and Public then click Next.
On the Name screen, enter SQL Server Named Pipes in the box and click Finish.
Repeat these steps for all of the entries in the table below.
Table 8 – SQL Server Firewall Port Exceptions
Protocol |
Port Number |
Name |
TCP |
445 |
SQL Server Named Pipes |
TCP |
1433 |
SQL Server Listening Port |
UDP |
1434 |
SQL Server Browser Service |