sql connection lost over ipsec VPN

[#1]

I have an ipsec vpn-tunnel between fg200 and fg60. When a dbconnection is inactive for some time (15minutes or so), the dbclient program looses its connection to the sql-server. On both devices: Keylife: 28800 Nat-traversal enabled Keepalive Fequency: 5 Dead Peer Detection enabled Any tips on how to resolve this?

[abelio]

you could try this with CLI, assuming you' re running MSSQL on standard 1433/tcp port (if not, or you' re using another DB or port, modify according to that) config system session_ttl config port edit 1433 set timeout 3600 next end end (Timeout MSSQL session = 1 hour) If you don' t have many dbconnections active at same time you could raise this timeout playing with timeout settings . hope it helps

[#3]

Raising the timeout worked fine :-) Do have have to use same value for both sides? Site A <-> Site B Site A hosts the MS-SqlServer it also host a website with lotsa db-connections.

[nsantin]

Are you using Oracle? If so then changing the timeout probably won' t work.

[abelio]

there' s one reference for the oracle situation: http://kc.forticare.com/default.asp?id=593&SID=&Lang=1

[#6]

if the sql session goes down, doesnt mean the tunnel goes down too?

[nsantin]

nope