Share via


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

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.


Additional resources