session state sql server session installation

http://support.microsoft.com/kb/317604

Steps to activate sql server session state

-for application server IIS Server
- Enable Service ASP.NET State Service
-Restart IIS


for DB server -
open command prompt as administrator
rutn this command

C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql.exe -S . -E -ssadd -sstype p

for your application write the connection string related session

<system.web>

    <sessionState mode="SQLServer" sqlConnectionString="Data Source=sourceInstance;Persist Security Info=True;User ID=sa;Password=psw" cookieless="false" timeout="20" />