ASP.Net MVC: Configuring asp.net session state in SQL Server.
Step 1 : Go to the command prompt and run the following commanad aspnet_regsql.exe -S <ServerName>- E -ssadd -sstype p where < ServerName > is the name of the server where your Database is located. here for my local machine we have given (local). Before running the command we need to check file v4.0.30319 on the following path C:\Windows\Microsoft.NET\Framework if it is not found then we need to install it. After running the command it will create database for SQL session tables. So now go to the SQL server and there we can see that it has created Database named “ASPState”. For more option here is the Link http://msdn.microsoft.com/en-us/library/ms229862(v=vs.80).aspx See the following image. Step 2: Now go to the Security Tab (outside the Database)> Login >app pool user here for my local system it is pspl-PC21\pspl Right click on app pool user ( pspl-PC21\p...