Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Step 15 - Enable SQL Firewall Ports

Updated: March 19, 2013

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.

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

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

    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.

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

    Protocols and Ports
  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


Port Number




SQL Server Named Pipes



SQL Server Listening Port



SQL Server Browser Service

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft