C:\Users\Administrator>netsh advfirewall firewall add rule name="SQL Server Whitelist 1.1.1.1" dir=in action=allow localport=1433 protocol=tcp remoteip=1.1.1.1Ĭ:\Users\Administrator>netsh advfirewall firewall add rule name="SQL Server Whitelist 1.1.8.10" dir=in action=allow localport=1433 protocol=tcp remoteip=1.1.8.10 Please note, if your ad-blocker app icon is not displayed in the Chrome toolbar, simply click the Extensions icon next to your profile icon, and then select your ad-blocker to open its options.
#HOW TO WHITELIST A WEBSITE ON A SONICWALL HOW TO#
Double click your rule, and choose the "Scope" tab to manage the allowed IPs.Īlternatively, if you like managing the list through the command line, you can create a separate rule for each IP. With the increase in remote workers globally, the IP whitelisting issues are significantly rising. how to whitelist a website in sonicwall plus Click on the Adblock Plus web browser extension icon in the browser address bar. Then choose "Inbound Rules" and you will see your "SQL Server Whitelist" rule in the main window. Or to avoid retyping the list every time you can use the user interface, under Start > Programs > Administrative Tools > Windows Firewall with Advanced Security. Then to manage the list, you can either run this command to update the list: C:\Users\Administrator>netsh advfirewall firewall set rule name="SQL Server Whitelist" new remoteip=1.1.1.1,1.1.8.10
In your case, just replace the list of IPs after remoteip= with a comma-separated list of the IPs you wish to whitelist. Would you like to do this through command line scripts or through the user interface? Not sure what you mean by flexibility, but I find it easiest to create firewall rules from the command line and then manage the list of whitelisted IPs through the user interface.Īssuming a new SQL Server installation, enabled Windows firewall, and no current allowance for SQL Server through the firewall, this command will set up a new rule with only the IPs you desire (run as Administrator): C:\Users\Administrator>netsh advfirewall firewall add rule name="SQL Server Whitelist" dir=in action=allow localport=1433 protocol=tcp remoteip=1.1.1.1,1.1.8.10
0 kommentar(er)
