Set a Windows firewall exception for the SQL Server port

You will need to set a Windows Firewall exception for a non-default SQL Server port number if you are using a remote node. Without access through the firewall, remote nodes will be unable to connect to the database.

To allow access through the Windows Firewall

1. Open Allow an app through Windows Firewall.

2. Select SQLServer from the list of applications. Double click to open the Edit a Port window.

3. Change the port number to match the port number listed in SQL Server Configuration Manager.

4. Click Network types... and select the checkbox that matches the network type to which you are connected (typically Domain).

For more information, refer to the following Microsoft documentation:

https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16