Pix firewall and sql server connection

[jallen]

I'm having strange issues with a pix 520 firwall running version 4.4. It appears to be running fine, except with connections to a sql server machine on the private network behind the firewall. I've opened port 1433 to the machine. Users who connect from the Internet through the PIX to sql enterprise manager get timeouts and the connection to sql server is very slow. In fact, I've opened up all ports to the box and its still hasn't help. Can someone offer suggestions/advice, I'm really in a bind. Thanks.

[tneuhuber]

Hi, try the following "fixup protocol sqlnet 1433"

[mcordiez]

I've found that with some apps (especially home-grown apps) you have to increase the timeout value on connections. I have just worked on a client site which required permanent SQL connections (even though no one used them for 12hrs at night). We upped the connection timeout to 3hrs vice 1 hr and have been running 2 wks without any complaints. Show Conn now shows about 30-50% more connections.