ASP.NET Session States in SQLServer for multiuser and loadbalancing solution





0/5 (0 vote)
This topic is for those who want to manage multi server websites and load balancing.Prerequisites:IIS 6.0 or higher.NET Framework 2.0,
This topic is for those who want to manage multi server websites and load balancing.
Prerequisites:
- IIS 6.0 or higher
- .NET Framework 2.0, 3.5
- VS 2008, 2005
- ASP.NET 2.0 or higher
How To in WinXP Professional?
- In SQL Server management consol
- Open file from path "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\InstallPersistSqlState.sql"
- Execute this script file on master database
- Go to command prompt of windows (Start->Run->cmd)
- Type net stop w3svc
- press Enter key
- Type net start w3svc
- press Enter key
- type iisreset
- press Enter key
- type net start aspstate
- press Enter key
- type aspnet_regsql
- press Enter key
- follow the instruction (by default next, next) (specify database aspstate)
- Type net stop w3svc
- press Enter key
- Type net start w3svc
- press Enter key
- type iisreset
- press Enter key
- type net start aspstate
- press Enter key
------------------------
- modify your web.config with following
cookieless="true"
timeout="20" /><machineKey validationKey='A130E240DF1C49E2764EF8A86CEDCBB11274E5298A130CA08B90EED016C0
14CEAE1D86344C29E67E99DF83347E43820050A2B9C9FC89E0574BF3394B6D0401A9'
decryptionKey='2CC37FFA8D14925B9CBCC0E3B1506F35066FEF33FEB4ADC8' validation='SHA1'/>