Search code examples
iis-7session-statesql-session-state

SQLServer SessionState

I am using InProc mode of SessionState, but my app is keep restarting because of the recycling of application pool so I am loosing session of currently logged in users. I want to change to save it in database. I edited my webconfig like this

<sessionState mode="SQLServer" timeout="20" allowCustomSqlDatabase="true"
    sqlConnectionString="Data Source=Server;integrated security=True;Initial Catalog=SerialTracker;"
    cookieless="false" />

Do I have to create some tables for session state or new database ? My hosting is shared so I can not acces to admin console or anything else.

Solution

  • There is a step by step HowTo available here. Seems you will be needing to run a SQL file named InstallSqlState.sql on the database.