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.

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

    Profile
  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

Protocol

Port Number

Name

TCP

445

SQL Server Named Pipes

TCP

1433

SQL Server Listening Port

UDP

1434

SQL Server Browser Service

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

Community Additions

ADD
Show:
© 2014 Microsoft