ASP.NET SQL Server Custom Session State Database Registration

Find aspnet_regsql.exe in the following dirs:

cd C:\Windows\Microsoft.NET\Framework\v4.0.30319
o
C:\Windows\Microsoft.NET\Framework\v2.0.50727

Run

aspnet_regsql.exe -S SqlServerDatabase -E -ssadd -sstype c -d CustomDatabasenameState

-S Sql Server Database

-d  Custom DatabaseName

-sstype c Custom Database

Sql Server connection

a) -E  Windows Authentication

b) -u username -p password

In the Web.Config

 --

 <system.web>

  

 <sessionState mode="SQLServer" sqlConnectionString="Data Source=CustomDatabasenameState ;

 Initial Catalog=ContraDevState;

 user id= sqlserverusername;

 password=sqlserverpassword; 

 Application Name= ApplicationName" 

 cookieless="false" 

 timeout="20" 

 allowCustomSqlDatabase="true" />

<!--  .................... -->

</system.web> --