Figure 3. Run SQL Query Analyzer. Configure SQL Server to support ASP.NET session state by using SQL Server Query Analyzer. Go to the Start menu and navigate to All Programs | Microsoft SQL Server | Query Analyzer. Ensure SQL Server Agent is running before running the SQL Scripts. The agent runs a periodic job to purge expired sessions from the database.