ODBC connection

  • 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.

  • Block them at the router/firewall. If it's a DMZ, you can do that.

  • 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

  • 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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply