ODBC Configuration

[jdl508]

Hello, I have a PIX 515r that has 3 int. I need to create an odbc connection from a server on dmz1 to a server on the inside. So far I have created a static for the db server on inside and can ping it by name or ip from the dmz. I also setup access-list to allow 1433 (MS SQL) in and out. here is my config any help is greatly appreciated


access-list 101 permit tcp any host x.x.65.180 eq www
access-list 101 permit icmp any any
access-list 101 permit tcp any host x.x.65.189 eq smtp
access-list 101 permit tcp any host x.x.65.190 eq smtp
<--- More --->

access-list 201 permit tcp host 10.1.10.5 host 10.0.20.7 eq 1433
access-list 201 permit tcp host 10.0.20.7 host 10.1.10.11 eq 1433
access-list 201 permit tcp host 10.1.10.11 host 10.0.20.7 eq 1433
access-list 201 permit tcp host 10.0.20.7 host 10.1.10.5 eq 1433
access-list 201 permit ip any host 10.0.20.7
access-list 201 permit ip host 10.0.20.7 any
pager lines 24
logging on
logging trap notifications
logging facility 1
logging host dmz2 10.0.20.4
interface ethernet0 10baset
interface ethernet1 10baset
interface ethernet2 10baset
mtu outside 1500
mtu dmz1 1500
mtu dmz2 1500
ip address outside x.x.65.178 255.255.255.248
ip address dmz1 10.1.10.1 255.255.255.0
ip address dmz2 10.0.20.1 255.255.255.0
ip audit info action alarm
ip audit attack action alarm
pdm history enable
arp timeout 14400
<--- More --->

global (outside) 1 x.x.65.179
global (dmz1) 3 10.0.20.254
nat (dmz1) 1 0.0.0.0 0.0.0.0 0 0
nat (dmz2) 3 10.0.20.0 255.0.0.0 0 0
static (dmz1,outside) x.x.x.x 10.1.10.5 netmask 255.255.255.255 0 0
static (dmz2,dmz1) 10.0.20.7 10.0.20.7 netmask 255.255.255.255 0 0
static (dmz2,outside) x.x.65.189 10.0.20.4 netmask 255.255.255.255 0 0
static (dmz2,outside) x.x.65.190 10.0.20.3 netmask 255.255.255.255 0 0
access-group 101 in interface outside
conduit permit icmp any any
route outside 0.0.0.0 0.0.0.0 x.x.65.177 1