locked
How to do sqlserver mode session RRS feed

  • Question

  • User1120488935 posted

    Hi I want store my session values in sqlserver

    what is procedure?

    Friday, August 12, 2011 10:17 AM

Answers

  • User541108374 posted

    Hi,

    HOW TO: Configure SQL Server to Store ASP.NET Session State

    Another way would be to follow these procedures: Session-State Modes.

    Grz, Kris. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 12, 2011 10:19 AM
  • User-1062158585 posted

    1. execute below path sqlquery

    \\WINDOWS\Microsoft.NET\Framework\v2.0.50727/InstallSqlState.sql

    aspnet_regsql.exe  //for install commnad prompt

    if it is .net 4.0  use  compressionEnabled="true"

    <sessionState
      mode="SQLServer"

      
       sqlConnectionString="Data Source=.;Initial Catalog=mural;Integrated Security=True;"
       cookieless="false"
       timeout="1"
      />

    If you are using trusted connections to connect to your server,
    you must change ownership of the state database to sa after creation. In Query Analyzer run use ASPState

    exec sp_changedbowner 'sa','true'


    goto security-> check u r user name has public and  local admin check boxes has checked or not

    aspnet_regsql -ssadd -S .sqlexpress -E -sstype p                 /*integrated security turned on */

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 12, 2011 10:22 AM

All replies

  • User541108374 posted

    Hi,

    HOW TO: Configure SQL Server to Store ASP.NET Session State

    Another way would be to follow these procedures: Session-State Modes.

    Grz, Kris. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 12, 2011 10:19 AM
  • User-1062158585 posted

    1. execute below path sqlquery

    \\WINDOWS\Microsoft.NET\Framework\v2.0.50727/InstallSqlState.sql

    aspnet_regsql.exe  //for install commnad prompt

    if it is .net 4.0  use  compressionEnabled="true"

    <sessionState
      mode="SQLServer"

      
       sqlConnectionString="Data Source=.;Initial Catalog=mural;Integrated Security=True;"
       cookieless="false"
       timeout="1"
      />

    If you are using trusted connections to connect to your server,
    you must change ownership of the state database to sa after creation. In Query Analyzer run use ASPState

    exec sp_changedbowner 'sa','true'


    goto security-> check u r user name has public and  local admin check boxes has checked or not

    aspnet_regsql -ssadd -S .sqlexpress -E -sstype p                 /*integrated security turned on */

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 12, 2011 10:22 AM