Asp.Net Sql Server Session Management

Question

I want to know if I have sqlstate session then do I need to create database for aspnetdb in the already (i.e. sampledb) existed database or I should have to create it separately. Suppose if I had create it in sampledb which is already existed then what connection-string path should I have to give in web.config and what changes would I have to make it on the time of deployment of the internet.

Please give me answer because there is lots of questions arising in my mind.

Denys Wessels · Accepted Answer · 2016-07-12 08:01:53Z

1

You should create a new database for the session state.

Configuring SQL Server session state is really simple and requires two simple steps:

Install ASPState database on your SQL server.

1.1 Open the command prompt and navigate to the folder where .NET Framework is installed on your machine e.g. C:\Windows\Microsoft.NET\Framework\v4.0.30319

1.2 Run the following command in the command prompt - aspnet_regsql.exe -S SampleSqlServer -E -ssadd -sstype p
Configure SQL server session state in the Web.config file to point to the ASPState database on your server.

Web.config:

<configuration>
  <system.web>
    <sessionState mode="SQLServer"
      sqlConnectionString="Integrated Security=SSPI;data 
        source=SampleSqlServer;" />
  </system.web>
</configuration>

Complete tutorial can be found here - Session-State Modes

edited Jul 12, 2016 at 8:01

answered Jul 12, 2016 at 7:55

Denys Wessels

17.1k16 gold badges85 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Asp.Net Sql Server Session Management

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related