topic Re: Pix firewall and sql server connection in Network Security https://community.cisco.com/t5/network-security/pix-firewall-and-sql-server-connection/m-p/63829#M713596 <HTML><HEAD></HEAD><BODY><P>Hi, try the following "fixup protocol sqlnet 1433"</P></BODY></HTML> Tue, 20 Nov 2001 15:14:54 GMT tneuhuber 2001-11-20T15:14:54Z Pix firewall and sql server connection https://community.cisco.com/t5/network-security/pix-firewall-and-sql-server-connection/m-p/63828#M713586 <P>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.</P> Fri, 21 Feb 2020 05:54:41 GMT https://community.cisco.com/t5/network-security/pix-firewall-and-sql-server-connection/m-p/63828#M713586 jallen 2020-02-21T05:54:41Z Re: Pix firewall and sql server connection https://community.cisco.com/t5/network-security/pix-firewall-and-sql-server-connection/m-p/63829#M713596 <HTML><HEAD></HEAD><BODY><P>Hi, try the following "fixup protocol sqlnet 1433"</P></BODY></HTML> Tue, 20 Nov 2001 15:14:54 GMT https://community.cisco.com/t5/network-security/pix-firewall-and-sql-server-connection/m-p/63829#M713596 tneuhuber 2001-11-20T15:14:54Z Re: Pix firewall and sql server connection https://community.cisco.com/t5/network-security/pix-firewall-and-sql-server-connection/m-p/63830#M713615 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 20 Nov 2001 18:34:14 GMT https://community.cisco.com/t5/network-security/pix-firewall-and-sql-server-connection/m-p/63830#M713615 mcordiez 2001-11-20T18:34:14Z