how could i permit the SQL service though a pix firewall and router

[xwang2]

how could i permit the SQL service though a pix firewall and router though access-list if the server is in the inside? Can sb give a sample?

Thanks

[mark.johnson]

I have 1 known user connecting to my MSSQL2000 server on the inside and he always connects with the same IP address, I've also limited it to a maximum of 10 connections:

access-list XXX permit tcp host 81.XXX.XXX.XXX host 62.XXX.XXX.XXX eq 1434

access-list XXX permit tcp host 81.XXX.XXX.XXX host 62.XXX.XXX.XXX eq 1433

static (inside,outside) 62.XXX.XXX.XXX 192.168.100.243 netmask 255.255.255.255 10 10

If you have multiple user connections you could try this:

access-list XXX permit tcp any host 62.XXX.XXX.XXX eq 1434

access-list XXX permit tcp any host 62.XXX.XXX.XXX eq 1433

static (inside,outside) 62.XXX.XXX.XXX 192.XXX.XXX.XXX netmask 255.255.255.255 10 10

Not to sure on the router, as I don't touch it.

Hope that’s some help to ya.

Mark