Error: Inbound traffic on TCP Port 1433 needs to be allowed on the SQL Server.

Problem:

Port 1433 is closed on the SQL server.

Solution:

Inbound traffic on TCP Port 1433 needs to be allowed on the SQL server.

  1. Connect to your SQL server.
  2. Open the Windows firewall.
  3. Click on Inbound Rules.
  4. Select New Rule.
  5. Add Servers wizard

  6. Select the Port type of the rule.
  7. Rule wizard - Port type

  8. Specify the ports to which this rule applies. In this case, 1433 stands for the SQL server, and 1434 for the SQL server browser.
  9. Rule wizard - Specify port

  10. In this step, leave the default selection: Allow the connection.
  11. Rule wizard - Allow the connection.

  12. Select the profiles for which this rule applies.
  13. Rule wizard - Profile - Domain
    Note: If the SQL server is in the same domain with other servers and you wish to open this port only for the domain traffic, it is enough to select Domain. For other scenarios use the Private or Public profile option.

  14. Specify the name and the description of this rule.
  15. Rule wizard - Choose name

  16. Inbound traffic on the SQL server is now allowed and SQL connection should be available!