Understanding StateServer and SQLServer
-
For my applications, I have always used "InProc" session state. But I want to understand how to build applications using StateServer and SQLServer. Can anyone point me to a relevant resource that shows how to build applications using StateServer and SQLServer. Thanks
-
For my applications, I have always used "InProc" session state. But I want to understand how to build applications using StateServer and SQLServer. Can anyone point me to a relevant resource that shows how to build applications using StateServer and SQLServer. Thanks
InProc is for a single server. StateServer and SQLServer are used when the app is on a server farm. http://www.codeproject.com/aspnet/ASPNETSession.asp
-
For my applications, I have always used "InProc" session state. But I want to understand how to build applications using StateServer and SQLServer. Can anyone point me to a relevant resource that shows how to build applications using StateServer and SQLServer. Thanks
Thanks for the above link According to the article, I need to run InstallSqlState.sql to use the SQLServer state. This script creates a new database in my SQL server. This is OK if I owned the SQL Server. However, i have a shared SQL server account, hosted by third party and therefore, I cannot create a DB myself. This means that people who have hosted databases, they cannot use SQLServer state for their asp.net applications.