How to allow SQL Traffic in WINDOWS FIREWALL Print

  • 0

Please follow the below steps to allow SQL express communication in the firewall.

  1. Open SQL Configuration Manager (You can find such an option from the start button)
  2. Expand SQL server network configuration and click on Protocol for SQL Server
  3. Enable TCP/IP.
  4. Right-click on TCP/IP and go to properties.
  5. Add port 1433 in all port text boxes.
  6. Restart the SQL server services.
  7. Go to windows firewall with advanced security
  8. Click on the inbound rule > New Rule > Port > TCP > Specific port (Add port 1433) > Allow connection > Name of the rule and click on save.
  9. Click on the outbound rule > New Rule > Port > TCP > Specific port (Add port 1433) > Allow connection > Name of the rule and click on save.

Was this answer helpful?

« Back