Configure the Windows firewall

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

• If you configured the default port 1433 or some other static port, you only need to allow inbound traffic via that port through the Windows firewall.

• If you did not configure a TCP port or you configured a dynamic port (0), the port changes in each startup. You then need to note the following:

  • You need to allow inbound traffic via the whole range of dynamic ports through the Windows firewall.

  • You need to open the UDP port 1434.

  • SQL Server Browser needs to be running on the server.

    Show/hide image

    

In this example, the default port 1433 is used.

Do the following:

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

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

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

4. On the right side of the dialog, 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 the port, such as 1433.

9. Click Next.

10. Select Allow the connection.

11. Click Next.

12. Select all the profiles taking the appropriate information security measures into account. In this example, all profiles are selected.

    

13. Click Next.

14. Enter a name for the firewall rule.

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

Next, define the main user of the CADMATIC Electrical SQL Server databases and create the databases.