Skip to main content
Install

Configure Windows Firewall for SQL based CS Professional Suite applications

This article provides basic instructions on how to add exceptions to Microsoft Windows Firewall to prevent problems operating CS Professional Suite SQL-based applications. Any other questions about setting firewall exceptions should be directed to your firm's IT professional.
If you're connecting a named instance through a firewall, you may need to configure the database engine to listen to a specific port, so that port can be opened in the firewall.
  1. Open the
    Control Panel
    .
  2. Select
    Administrative Tools
    .
    note
    The path to
    Administrative Tools
     depends on the
    Control Panel
     view.
    • In Category view, select
      System and Security
       and then
      Administrative Tools
      .
    • In Small or Large icon view, select
      Administrative Tools
      .
  3. Open
    Windows Firewall with Advanced Security
    .
  4. Select
    Inbound Rules
     and then
    New Rule
    .
  5. In the
    New Inbound Rule Wizard
    , use the following information to create a port exception.
    1. Select
      Port
      .
    2. Select
      TCP
       and specify port 1433.
    3. Allow the connection.
    4. Select all 3 profiles (Domain, Private, and Public).
    5. Name the rule SQL Server TCP 1433.
  6. Select
    New Rule
     again and use the following information to create another port exception.
    1. Select
      Port
      .
    2. Select
      UDP
       and specify port 1434.
    3. Allow the connection.
    4. Select all 3 profiles (Domain, Private, and Public).
    5. Name the rule SQL Server UDP 1434.
  7. Select
    New Rule
     again and use the following information to create a program exception.
    1. Select
      Program
      .
    2. Select
      Browse
       to select sqlserver.exe and the applicable location. Your path might look like
      C:\Program Files\Microsoft SQL Server\MSSQL[SQLVersion]<instance_name>\MSSQL\Binn
      .
    3. Allow the connection.
    4. Select all 3 profiles (Domain, Private, and Public).
    5. Name the rule sqlserver.exe.
  8. Select
    New Rule
     again and use the following information to create another program exception.
    1. Select
      Program
      .
    2. Select
      Browse
       to select sqlbrowser.exe at this location:
      C:\Program Files\Microsoft SQL Server\90\Shared
    3. Allow the connection.
    4. Select all 3 profiles (Domain, Private, and Public).
    5. Name the rule sqlbrowser.exe.

This article applies to:

  • Product: Workpapers CS
  • Subject: SQL