session timeouts?

16 Dec 2005 8:45 PM

rmanchu

hi

i'm new to sql server.

i'm finding that when a connection sql server is idle for sometime, it
gets disconnected ??? is there a session timeout for sql server
connections? what's the default value for this?

currently, i'm refreshing the connection every 100 seconds with a
meaningless query, which seems to work pretty goood.

riyaz

16 Dec 2005 8:49 PM

Mike Epprecht (SQL MVP)

Hi

SQL Server from it self does not close down connections based on a timeout.

Either your firewalls/routers are closing ports after a period of
inactivity, or if you are a web application, the session is timing out.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<rman***@gmail.com> wrote in message
Show quote

news:1134765946.171747.156120@o13g2000cwo.googlegroups.com...
>
> hi
>
> i'm new to sql server.
>
> i'm finding that when a connection sql server is idle for sometime, it
> gets disconnected ??? is there a session timeout for sql server
> connections? what's the default value for this?
>
> currently, i'm refreshing the connection every 100 seconds with a
> meaningless query, which seems to work pretty goood.
>
> riyaz
>

16 Dec 2005 9:06 PM

rmanchu

i'm using from my laptop, so there's no firewalls or anything of the
sort.

am using ADODB v2.8

i'm accessing the sql server via http over the internet.

well ... as a backup measure i'd better keep running a connection
refresh query periodically

riyaz