SessionState SQL Server timeout doesn't work

Expand Post »

Dear all,

I have a problem for my session state.
Previously, I used session state InProc, but because CPU usage was very high cause IIS sometimes restarts, so I changed it to SQLServer.

but now, session doesnt want to expire even I set timeout to 1 minute !!!.

this is my session state syntax.

ASP.NET Syntax (Toggle Plain Text)
<sessionState mode="SQLServer" cookieless="false" regenerateExpiredSessionId="true" timeout="1" sqlConnectionString="Data Source=xxx.114.30.xx;UID=sa;pwd=****;Integrated Security=false;" sqlCommandTimeout="90"/>
<sessionState mode="SQLServer" cookieless="false" regenerateExpiredSessionId="true" timeout="1" sqlConnectionString="Data Source=xxx.114.30.xx;UID=sa;pwd=****;Integrated Security=false;" sqlCommandTimeout="90"/>

Could you help me to solve my problem?

I use SQL Server 2005, Windows 2003 Server and IIS 6.

Thanks

Similar Threads

VB 08 sql server database login form, using a column made in the data set designer in VB.NET
Access & MS SQL Server 2005 in MS SQL

Kusno

Reputation Points: 11

Solved Threads: 17

Junior Poster

Offline

191 posts
since Aug 2007

Permalink

Jul 30th, 2009

Re: SessionState SQL Server timeout doesn't work

i think you need to use Session.Abandon() method to kill the session...

kameswari

Reputation Points: 13

Solved Threads: 16

Junior Poster in Training

Offline

76 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Problem in Updating Gridview.

Next Thread in ASP.NET Forum Timeline: Stack Oveflow

DaniWeb Message

Cancel Changes

User Name
Password