Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markpringle
Starting Member
11 Posts |
 Posted - 2011-09-04 : 11:23:20
|
| 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?"Kindness is not a weakness, the contrary on the other hand is." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
markpringle
Starting Member
11 Posts |
Posted - 2011-09-05 : 11:42:49
|
quote:
Originally posted by tkizer
You'll need to do this at the firewall level and not at the SQL level. You could check out your Windows firewall or your network firewall.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
OK, I've used my Windows firewall to block ALL incoming SQL connections. 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?"Kindness is not a weakness, the contrary on the other hand is." |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Allow remote connections from specific IP?
Tara Kizer