Configure the Windows firewall

You have to allow inbound traffic via the 1433 port through the Windows firewall.

Do the following:

1. In the Windows search box, enter wf.msc.

   Show/hide image

   

2. Open the program. The Windows Defender Firewall with Advanced Security window opens.

3. On the left side of the window, select Inbound Rules.

4. On the right side of the window, click New Rule. The New Inbound Rule Wizard dialog opens.

   

5. Select Port.

6. Click Next.

7. Select TCP.

8. For Specific local ports, enter 1433 as the value.

9. Click Next.

10. Select Allow the connection.

11. Click Next.

12. Select all the profiles for this example. In a customer environment, take the appropriate information security measures into account.

13. Click Next.

14. Enter a name for the fire wall.

15. Click Finish. Traffic through the firewall to the SQL Server instance is now allowed and connection outside of the server is possible.

Next, take SQL Server project management into use.