ASP.NET sessionState SQLServer mode timeout doesn't work
<p>I've configured the sessionState to use the custom SQL server below and set it to be expired after 1 minute. It seems like the session always remain on the browser and sql server. I even set the regenerateExpiredSessionId to false and still having the same problem. I am running asp.net 4.0 under IIS 7 windows 7 pro.</p>

<p>My web.config configuration</p>

<pre><code>&lt;sessionState mode="SQLServer" allowCustomSqlDatabase="true" sqlConnectionString="Data Source=MYCON\SQL2008REXPRESS;Initial Catalog=DBASPState; User ID=DB1543Write;Password=test" timeout="1" sqlCommandTimeout="10" regenerateExpiredSessionId="false" stateNetworkTimeout="10" compressionEnabled="true" cookieless="false" /&gt;
</code></pre>

<p>I've checked the table ASPStateTempSessions in the  sessionstate database and saw records within it. Read and write, owner permission is current configured with urrent user of this database. There is no errors from "Even Viewer".</p>

<p>I've checked the value from the ASPStateTempSessions table and below it seems like the session is off compare to 5 hours compare 1 minute. It seems like asp.net configured it to be expired within 1 minute using another timezone instead of the current machine timezone.</p>

<p>My current time is 12/17/2011 11:29 AM
Database columns had the value  CreatedDate(column)  2011-12-17 17:29:01.677
Expires(column) 2011-12-17 17:30:03.903</p>

<p><strong>Full details on the database value is below.</strong></p>

<p>The first record is when i first visit my website</p>

<pre><code>SessionId, Created, Expires, LockDate, LockDateLocal, LockCookie, Timeout, Locked, SessionItemShort, SessionItemLong, Flags
0wtp4j0traj5e0gydygkyoe22476b033    2011-12-17 17:29:01.677 2011-12-17 17:30:03.903 2011-12-17 17:29:03.873 2011-12-17 11:29:03.873 11  1   False   &lt;Binary data&gt;   NULL    0
</code></pre>

<p>After I pressed the "Refresh" button on my browser, the record was updated with the new expired time but the session information is still there</p>

<pre><code>0wtp4j0traj5e0gydygkyoe22476b033    2011-12-17 17:29:01.677 2011-12-17 17:37:08.910 2011-12-17 17:36:08.907 2011-12-17 11:36:08.907 13  1   False   &lt;Binary data&gt;   NULL    0
</code></pre>

<p>Any ideas?</p>
