This article will walk you through creating rules in Windows Advanced Firewall to block remote SQL connections.
By default when enabled Windows Advanced Firewall blocks all incoming traffic unless a rule exists stating otherwise.
Connect to your server via Remote Desktop
* Click Start > Administrative Tools > Windows Firewall with Advanced Security
* Select Windows Firewall with Advanced Security on Local Computer
* Select Windows Firewall Properties
* Ensure Firewall State is On for each tab; Domain Profile, Private Profile, and Public Profile Click OK
* Select Inbound Rules > Select New Rule > Select Port and Click Next
* Enter 1433 under Specific local ports and Click Next
* Select Allow the connection and Click Next
* Click Next
* Enter a Name and Description for the rule and Click Finish
* Right-Click on the newly created Allow Rule and Select Properties
* Click the Scope Tab
* Under Remote IP Address Select These IP addresses and Click Add
* Enter either your IP, IP/subnet or IP Range and click OK
* Click OK
By default when enabled Windows Advanced Firewall blocks all incoming traffic unless a rule exists stating otherwise.
Connect to your server via Remote Desktop
* Click Start > Administrative Tools > Windows Firewall with Advanced Security
* Select Windows Firewall with Advanced Security on Local Computer
* Select Windows Firewall Properties
* Ensure Firewall State is On for each tab; Domain Profile, Private Profile, and Public Profile Click OK
* Select Inbound Rules > Select New Rule > Select Port and Click Next
* Enter 1433 under Specific local ports and Click Next
* Select Allow the connection and Click Next
* Click Next
* Enter a Name and Description for the rule and Click Finish
* Right-Click on the newly created Allow Rule and Select Properties
* Click the Scope Tab
* Under Remote IP Address Select These IP addresses and Click Add
* Enter either your IP, IP/subnet or IP Range and click OK
* Click OK
No comments:
Post a Comment