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

  • Article

APPLIES TO: yes-img-132013 yes-img-162016 yes-img-192019 yes-img-seSubscription Edition no-img-sopSharePoint in Microsoft 365

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 SQL Server Configuration Manger, start the SQL Server Agent service.