How To allow SQL Express traffic in windows firewall

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.

If you need any help then you can check Server Migration | Server Management | Server Security (activeservers.in)

  • VPS, windows, vps hosting, windows hosting, SQL, sqlexpress, firewall
  • 5 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

Backup restoration

Since backups are saved at various nodes to avoid data loss, we manage the backup and...

How to change SQL authentication in SQL Express

Please follow the below steps Login to SQL Express using SQL management studio. Right-click...

Set Up Sending of Email in Plesk

To Set Up Sending of Email in Plesk, You need to follow the below Points   1. Go to Tools...

How to check Port status of VPS

It may possible that the firewall has blocked a few ports and it is not accessible.  To check...

How to create Database in ubuntu with command line

Please follow the below commands to create a database and user in ubuntu with command line...