Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Pix firewall and sql server connection

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.

2 REPLIES
New Member

Re: Pix firewall and sql server connection

Hi, try the following "fixup protocol sqlnet 1433"

New Member

Re: Pix firewall and sql server connection

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.

138
Views
0
Helpful
2
Replies