sql server access from dmz

[peter.saldanha]

Hi

I have a sql server inside and a webserver in the dmz. I want to access sql from inside and outside via web server on dmz interface. I need to have internet access in dmz web server but for the inside LAN the internet access must be through different ADSL line. How do I do this route diversion?

The following is my configuration

PIX Version 6.3(4)

interface ethernet0 auto

interface ethernet1 auto

interface ethernet2 auto

nameif ethernet0 outside security0

nameif ethernet1 inside security100

nameif ethernet2 dmz security4

enable password xxx

passwd xxx

hostname pfw1

fixup protocol dns maximum-length 512

fixup protocol ftp 21

fixup protocol h323 h225 1720

fixup protocol h323 ras 1718-1719

fixup protocol http 80

fixup protocol rsh 514

fixup protocol rtsp 554

fixup protocol sip 5060

fixup protocol sip udp 5060

fixup protocol skinny 2000

fixup protocol smtp 25

fixup protocol sqlnet 1521

fixup protocol tftp 69

names

access-list acl_out permit tcp any host public_ip3 eq www

access-list acl_out permit tcp any host public_ip3 eq https

access-list acl_out permit tcp any host public_ip3 eq ftp

access-list acl_out permit tcp any host public_ip3 eq ftp-data

access-list acl_dmz permit tcp host 192.168.1.1 90.0.0.0 255.255.255.0 eq www

access-list acl_dmz permit tcp host 192.168.1.1 90.0.0.0 255.255.255.0 eq https

access-list acl_dmz permit tcp host 192.168.1.1 90.0.0.0 255.255.255.0 eq ftp

access-list acl_dmz permit tcp host 192.168.1.1 90.0.0.0 255.255.255.0 eq ftp-da

ta

access-list acl_dmz permit tcp host 192.168.1.1 90.0.0.0 255.255.255.0 eq 1433

pager lines 24

mtu outside 1500

mtu inside 1500

mtu dmz 1500

ip address outside public_ip1

ip address inside 90.0.0.100 255.255.255.0

ip address dmz 192.168.1.100 255.255.255.0

ip audit info action alarm

ip audit attack action alarm

pdm history enable

arp timeout 14400

global (outside) 1 interface

nat (dmz) 1 192.168.1.0 255.255.255.0 0 0

static (dmz,outside) public_ip3 192.168.1.1 netmask 255.255.255.255 0 0

static (inside,dmz) 90.0.0.0 90.0.0.0 netmask 255.255.255.0 0 0

access-group acl_out in interface outside

access-group acl_dmz in interface dmz

route outside 0.0.0.0 0.0.0.0 public_ip2 1

timeout xlate 3:00:00

timeout conn 1:00:00 half-closed 0:10:00 udp 0:02:00 rpc 0:10:00 h225 1:00:00

timeout h323 0:05:00 mgcp 0:05:00 sip 0:30:00 sip_media 0:02:00

timeout uauth 0:05:00 absolute

aaa-server TACACS+ protocol tacacs+

aaa-server TACACS+ max-failed-attempts 3

aaa-server TACACS+ deadtime 10

aaa-server RADIUS protocol radius

aaa-server RADIUS max-failed-attempts 3

aaa-server RADIUS deadtime 10

aaa-server LOCAL protocol local

no snmp-server location

no snmp-server contact

snmp-server community public

no snmp-server enable traps

floodguard enable

telnet 90.0.0.0 255.255.255.0 inside

telnet 192.168.1.0 255.255.255.0 dmz

telnet timeout 5

ssh timeout 5

console timeout 0

terminal width 80

Cryptochecksum:xxx

: end

[OK]

pfw1#

[harishtandon23]

what i understand from this is that you have the webserver on the dmz and sql server on the inside. you want users on the inside to access the webserver from inside using the url and the outside public on the internet also be able to access the dmz webserver from the internet. You want internet access on the dmz and the inside network as well. but you only want the web server on the dmz to access the inside sql server.

If i understand you correct, please send me the details of the ip address and the port no, so that i can send you the correct commands to be issued on the pix firewall.

I need the inside sql server's private ip address, DMZ's webserver's private ipaddress. Also let me know if you are using the ISP DNS server to get to the internet or you also have you inside DNS server. Tell me the SQL port no that need to be access from the dmz webservers.

If you have any questions, please feel free to contact me.

Thanks & Regards,

Harish Tandon

harishtandon23@gmail.com