September 4, 2011 at 9:24 am
My MS SQL Server 2008 R2 instance is setup to allow remote connections. However, I only want to allow remote connections from specific IP addresses via windows firewall, and block all others. How do I do this?
September 4, 2011 at 10:10 am
You would setup your SQL instance to listen on a specified port and then configure your firewall to allow traffic only from specific IPs to connect using that port.
How to: Configure a Windows Firewall for Database Engine Access
Joie Andrew
"Since 1982"
September 5, 2011 at 9:44 am
Joie Andrew (9/4/2011)
You would setup your SQL instance to listen on a specified port and then configure your firewall to allow traffic only from specific IPs to connect using that port.How to: Configure a Windows Firewall for Database Engine Access
OK, I've used my Windows firewall to block ALL incoming SQL connections (That works). Then, I created another rule to allow certain IP Address. However, the Block rule is overriding the Allow rule. How do I get the Allow rule to supersede the Block rule?
September 5, 2011 at 3:44 pm
OK, I've used my Windows firewall to block ALL incoming SQL connections (That works). Then, I created another rule to allow certain IP Address. However, the Block rule is overriding the Allow rule. How do I get the Allow rule to supersede the Block rule?
If the rule for the specific IP is set correctly then it should be blocking ALL connections made on your specified SQL port except for the IP address you specified. Therefore you shouldn't need the block ALL rule.
Joie Andrew
"Since 1982"
September 5, 2011 at 4:02 pm
If the rule for the specific IP is set correctly then it should be blocking ALL connections made on your specified SQL port except for the IP address you specified. Therefore you shouldn't need the block ALL rule.
Sorry, forgot to mention that my VPS provider has a default rule that cannot be changed and allows everything VIA port 1433. So, thats why i need a block all rule.
September 6, 2011 at 7:24 am
which operating system is the machine using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2011 at 7:30 pm
Check this one
http://www.sqlservercentral.com/Forums/Topic1031530-146-1.aspx
Thank You,
Best Regards,
SQLBuddy
July 31, 2017 at 6:33 am
This was removed by the editor as SPAM
July 31, 2017 at 8:41 am
6 year old post!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply