Expired sessions are not being deleted from the ASP.NET Session State database (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010

Rule Name:   Expired sessions are not being deleted from the ASP.NET Session State database

Summary:   If expired sessions are not deleted, the server that hosts the ASP.NET Session State database may run out of disk space and the SharePoint farm may cease to function.

Cause:   One or more of the following might be causing this:

  • The SQL Server Agent service was stopped.

  • SQL Server Express is installed.

    Important

    You cannot run the SQL Server Agent service on an instance of SQL Server Express.

Resolution:   Start the SQL Server Agent service

  1. Verify that the user account that is performing this procedure is a member of the Administrators group on the database server that is hosting the ASP.NET Session State database.

  2. In the Services snap-in, start the SQL Server Agent service.