Open a static port in the Windows firewall for TCP access

  1. On the database server, choose Start → Control Panel.

    The Control Panel window appears.

  2. Double-click Windows Firewall.

    The Windows Firewall dialog box appears.

  3. In the left pane, click Advanced settings.

    The window refreshes to display a left, center, and right pane of advanced options.

  4. In the left pane, click Inbound Rules.

    The center and right panes refresh to display different options.

  5. In the right pane, click New Rule.

    The New Inbound Rule Wizard appears, set to the Rule Type screen.

  6. Select Port, and then click Next >.

    The Protocol and Ports screen of the wizard appears.

  7. Verify that TCP and Specific local ports are selected.
  8. In Specific local ports, type a port number.

    Note: Port 1433 is used in most cases, and is the default port for SQL Server.

  9. Click Next >.

    The Action screen of the wizard appears.

  10. Verify that Allow the connection is selected, and then click Next >.

    The Profile screen of the wizard appears.

  11. Clear Public, and then click Next >

    The Name screen of the wizard appears.

  12. In Name, type a name for the rule.

    Example: SQL1433Port

  13. (Optional) In Description, type additional information describing the rule you have set up.
  14. Click Finish.
  15. Close the Windows Firewall window.
  16. Close the Control Panel window.