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.
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.