Hi, Tim.
Reinstalling IIS is not needed.
What you need to do is make sure that the
DeleteExpiredSessions stored procedure
is run by a SQL Server Agent as a job.
The InstallSqlState.sql script should have created the
job called ASPState_Job_DeleteExpiredSessions.
If, for any reason at all, that didn't happen,
look for InstallSqlState.sql in the .
%windir%\Microsoft.Net\Framework\v1.1.4322 directory,
if you're using .Net Framework 1.1, or the appropiate
version number directory if using a different version.
If you don't have critical data yet, it probably would be
easier to drop the whole shebang by running the
"UninstallSqlState.sql" script found in the same directory,
and then reinstalling it by running InstallSqlState.sql again
( using SQL Server Query Analyzer for both ).
Then, make sure that SQL Server Agent
is run automatically when Windows starts
( Administrative Tools -> Services, look for SQL Server Agent,
and set to automatic startup )
That should get you up and running.
Let us know how you make out.
I will not be available after tomorrow ( 2 week vacation ),
but there's any number of good people here who can help.
Juan T. Llibre
===========
"Tim W." <Cy************@newsgroup.nospam> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Hi Juan,
first checked whether Agent is running: it is! Nonetheless: I don't think
ASPStats_Job_DeleteExpiredSessions is registered. How can I make sure,
and is there a way to setup this job other than re-installing the whole
IIS?
Tim
"Juan T. Llibre [MVP]" <no***********@nowhere.com> schrieb im Newsbeitrag
news:e4**************@TK2MSFTNGP15.phx.gbl... Is SQL Server Agent running ?
See http://www.dbazine.com/cook9.shtml
"The InstallSqlState.sql script creates a job called
ASPState_Job_DeleteExpiredSessions to delete
expired sessions from tempdb.
Recall that ASP.NET does not keep session resources
alive indefinitely. To support this feature when a SQL Server
is used to maintain state, the SQL Server Agent must be running
so that the expired session deletion job runs as needed.
By default, the job is scheduled to run every minute. It deletes
session state rows with an Expires value less than the current time.
The account under which the SQL Server Agent runs must have the
privilege to execute the DeleteExpiredSessions stored procedure."
---000---
If SQL Server Agent isn't running,
The DeleteExpiredSessions job can't run.
I hope that's it!
Juan T. Llibre
===========
"Tim W." <Cy************@newsgroup.nospam> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl... Folks.
In a B2B Procurement system we've created, we got following
Session-Issue:
Configuration: We are using IIS 6.0 and added SQL-Based-Sessions in
web.config with a timeout of 240 minutes and set them to cookieless
mode.
As well we added Session.Timeout=240 in asp.net-application and saved
data
into the session.
Session-Timeout in IIS is also set to 240.
When looking at the ASPStateTempSessions table, we can see Expires field
which has the correct expirery-value.
Problem: We don't ever get any timeout. Session seems to be still alive
after 14 hours. If we call session with session-id in url, we get all
values we set before out of the session.
As well we tried to set session-timeout to 1minute, but same thing
happened (in application and IIS and web.config) Also we tried to
disable
Session-State in IIS. But everytime the same result: Session gets not
destroyed (Session.Abandon()) after expirery-time passed.
Did we overlook something? What keeps the session alive?
Thanks for help in advance,
Tim (Cy************@newsgroup.nospam)