This issue happens when the firewall is blocking the SQL port to allow other inbound connections due to the SQL exception not allowed on the Firewall,
Follow the below steps to resolve this issue:
Create Inbound Rules for the SQL Server Ports
This method will target the specific ports SQL Server uses for communication.
- Open Windows Control Panel and select System and Security.Click to Enlarge
- From the System and Security window, click Windows Defender Firewall.Click to Enlarge
- From the Windows Defender Firewall window, click Advanced Settings.Click to Enlarge
- Add the port SQL uses for TCP.
From the Windows Defender Firewall with Advanced Security window:
Select Inbound Rules from the left hand column.
Click New Rule... from the Actions column.
Click to Enlarge
- From the New Inbound Rule Wizard, select Port.
Click Next.
Click to Enlarge
- Select TCP.
Select Specific local ports.
Enter 1433.
Click Next.
Click to Enlarge
- Select Allow the connection.
Click Next.
Click to Enlarge
- Select Domain, Private and Public.
Click Next.
Click to Enlarge
- Enter a name for the rule.
For example: SQL TCP.
