sql connection lost over ipsec VPN

Forum|Forum|20 years ago
April 12, 2006
3 replies
3838 views

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

SuperUser

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

A

Anonymous_UserAuthor

Contributor

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.