Enable Networking for SQL Server Express

Enable Networking

1. Open SQL Server Configuration Manager.
   

   

2. Using the left-hand navigation panel, select SQL Server Network Configuration, the select Protocols.
   

   

3. Right-click Named Pipes, then click Enable.
4. Right-click TCP/IP, then click Enable.
5. Double-click TCP/IP, then click the IP Addresses tab.
6. Find the IP Address you want SQL to broadcast on, then set the TCP Port value to 1433.
   1. If you would like to broadcast on all interfaces, scroll down to the IPALL group and set the TCP Port to 1433.
      

      

7. On the left-hand navigation panel, click the SQL Server Services group.
8. Right-click the SQL Server instance then click Restart.
   

   

9.  Finally, double-click the SQL Server Browser service.
10. Under the Service tab, change Start Mode to Automatic then click Apply,
11. Under the Log On tab, click Start, then click Ok.

Create Firewall Rules

1. Open Windows Defender Firewall with Advanced Security.
   1. Click the Start button, then type Advanced Security.
      

       

   2. Click Windows Defender Firewall with Advanced Security when it appears.
   3. On the left-hand navigation pane, click Inbound Rules.
   4. Click New Rule... on the right-hand Action pane.
      

      

   5. On the New Inbound Rules Wizard, click Port then click Next.
   6. Verify that TCP is selected and enter 1433 into the Specific Local Ports textbox.
   7. Click Next.
   8. Select Allow the Connection, then click Next.
   9. Leave all the networking groups selected, then click Next.
   10. Give the Rule a descriptive name. Example: SQL Server TCP Ports
   11. Click Finish.
   12. On the left-hand navigation pane, click Outbound Rules.
   13. Click New Rule... on the right-hand Action pane.
       

       

   14. On the New Outbound Rules Wizard, click Port then click Next.
   15. Verify that TCP is selected and enter 1433 into the Specific Local Ports textbox.
   16. Click Next.
   17. Select Allow the Connection, then click Next.
   18. Leave all the networking groups selected, then click Next.
   19. Give the Rule a descriptive name. Example: SQL Server TCP Ports
   20. Click Finish.