SQL Session state configured by inProc still being used

Discussion in 'General troubleshooting' started by Andy Brown, Jun 5, 2014.

  1. Hi,

    I'm trying to configure SQL Session state for my app. I've had the database configure, and added the following to my web.config

    <sessionState allowCustomSqlDatabase="true" cookieless="UseCookies" mode="SQLServer" sqlConnectionString="Data Source=<my server>;Initial Catalog=<mydb>_sessionstate;Integrated Security=False;User ID=<myuseR>_sessionstate_user;Password=<mypassword" timeout="1500" /> 
    However my app doesn't seem to be using the database, if I login and then query the ASPStateTempSessions table there is no session data stored.

    I've also tried entering incorrect connection string the web.config to see if it raises and error to confirm the setting is being picked up, but no error is thrown.

    Any ideas???
  2. FredC

    FredC Winhost Staff

    Is the web.config located in the web application root?
    Michael likes this.
  3. ComputerMan

    ComputerMan Winhost Staff

    Last edited by a moderator: Oct 14, 2015
    Michael likes this.

Share This Page