August 4, 2004 at 7:57 am
I wanted to know if there is a way to restrict ODBC connections by IP address. I have two servers in a DMZ but only want to allow one to connect to my SQL server. Any help, suggestions would be greatly appreciated.
August 4, 2004 at 11:09 am
Block them at the router/firewall. If it's a DMZ, you can do that.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 4, 2004 at 1:02 pm
IPSec policy as well. You can set a policy on the SQL Server to specifically block that IP. Defense in depth. That way if a configuration change happens on the firewall and suddenly allows connections inbound, you've still got the IP blocked at the server.
K. Brian Kelley
@kbriankelley
August 5, 2004 at 5:49 am
Thanks bkekkey. Thats what I was looking for, I already have the firewall configured to block just wanted something else. Thanks again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply