How to use sqlserver to store session state?

Question

<sessionState mode="SQLServer"
  cookieless="true"
  regenerateExpiredSessionId="true"
  timeout="30"
  sqlConnectionString="Data Source=MICHAEL;Integrated Security=SSPI;"
  stateNetworkTimeout="30"/>

I wonder what I'm doing wrong.

Answer 1

Did you run the aspnet_regsql tool to configure the SQL server?

command example:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -S MICHAEL -E -ssadd -sstype t