Hi, I'm having trouble converting the sessionState to mode="SQLServer". I've inseted the following in the Web.config file (the main .config file): <sessionState mode="SQLServer" allowCustomSqlDatabase = "true" sqlConnectionString="data Source=tcp:esql2k1201.discountasp.net;Initial Catalog=SQL2012_etc;user id=SQL2012_etc_user;password=myPassword;Integrated Security=SSPI" sqlCommandTimeout ="30" cookieless="false" timeout="100" /> where "myPassword" substitutes for the real thing and the discountASP.net guys have already installed the relevant schema on that database. When I log into my site and then check the ASPStateTempSessions table there are no records - so doesn't seem to have converted the session state from "InProc" to "SQLServer". I'm using MVC3 and IIS7. Is there something I'm missing here? Anyone come across something similar? Cheers, Rob
Rjukes, Were you ever able to figure this out? If you would like, PM me your customer ID # and I will look into your database and do some snooping.
That's kind - thanks! I've not managed to resolve the issue, but I'm not permissioned to be able to send private messages - is there another way I can send my details? Thanks, Robert.
Rjukes, I’m sorry about the delay in my response. I double checked your database, the SQL Session tables that should have been created are blank. I suggest that you contact the support department and have them re-create SQL Server Session Schema for you. In addition I feel like I should bring up the following thing with you about the connection string in your web.config file. cookieless="false" According to the knowledge base article on SQL Server Session, you should have cookieless set to “true”. I would make doubly sure that you want this settings to false and/or set it true before you have Session schema re-created for you, and see if you notice any difference.
