How To
How To - Add SQL Server to Windows Firewall Exception
How to add SQL Server to Windows Firewall Exception
- Open Windows Defender Firewall with Advance Security. (Using windows key and type).
- Adding sqlsvr.exe
- Create New Inbound Rule, Select Rule Type as ‘Program’, click on Next button.
- Click the "Browse" button and then navigate to you SQL Server installation path and click next. I.e: ‘C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2014\MSSQL\Binn\’
Here, choose the file called sqlservr.exe and add it. The navigate to:
- Allow the connection for Action, click next.
- Specify all the profiles for which the rules applies, click next.
- Give an appropriate name for the rule, click finish.
- Adding Inbound Rules for TCP PORT.
- Create New Inbound Rule, Select Rule Type as ‘Port’, click next button.
- Select port as ‘TCP’ and Specific local port as ‘1433’, click next.
(Generally local ports ‘1433' will be the same in most cases. If it is not same then it should require to check in the sql server configuration manager.)
- Allow the connection in Action and click next.
- Specify all the profiles for which the rules applies, click next.
- Give an appropriate name for the rule, click finish.
- Adding Inbound Rules for UDP PORT.
- Create New Inbound Rule, Select Rule Type as ‘Port’, click next button.
- Select port as ‘UDP’ and Specific local port as ‘1434’, click next.
- Allow the connection in Action and click next.
- Specify all the profiles for which the rules applies, click next.
- Give an appropriate name for the rule, click finish.
Once finished all the settings, test the database connection between the server computer and the client/bridge computer.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article