Re: Session disconnects
- From: "William Vaughn" <billvaNoSPAM@xxxxxxxxx>
- Date: Thu, 13 Sep 2007 17:02:42 -0700
I would post this to the ms.public.sqlserver group... but I can't say that I've heard of a session disconnect setting in SQL Server. I have seen evidence of this behavior though in years past. In some cases it was traced to a NIC timeout, network malfunction (where the ACK/NAK was not received in time), or other network issues. We generally had our connected applications "ping" the server with a query or some operation from time to time to eliminate the problem without really finding the cause.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Randy Galliano" <r_galliano@xxxxxxxxx> wrote in message news:O7ADGJV9HHA.5404@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I am quite new to sql 2005. We have an application that was using msde. We recently moved it to sql 2005 and now we get idle sessions disconnected after about 20 minutes. I have searched the doc for answers and can't find any. Where are the session auto disconnection times set in sql?
Regards,
Randy.
.
- References:
- Session disconnects
- From: Randy Galliano
- Session disconnects
- Prev by Date: Re: SQLExpress New DB
- Next by Date: Re: How to connect to our internal SQL Server from outside webserver
- Previous by thread: Session disconnects
- Index(es):
Relevant Pages
|
