I've come across a problem w/ a home-grown application on a DMZ opening a connection to an internal SQL server through a PIX. The app seems to want to open a connection and keep it open forever. The Pix, as per default, drops the connection after an hour. In response to irrate developers we've upped the timeout value to 3 hrs, hoping that at least some traffic would flow through that socket within that time-period.
Has anyone else come across a similar problem? Have you any other thoughts on settings that could be changed. We'd like to limit the timeout value somewhat and are pushing the developers to write in some type of keep-alive transaction (slim chance).
Regards