ASP.NET offers three session management solutions. They are:
- StateServer (outProcess),
- SQLServer (based on the database)
Today I spent about 3 hours just to get the configuration right for using this third type called SQLServer based Session State Management. I ended up configuring it on SQL Server 2000,
Well, in short this is what my command looked like:-
Its very important that you set the allowCustomSqlDatabase=“true” coz you wont be able to get it running without this — atleast that’s what I’ve learnt in the last 3-4 hours.
Hope that helps,