Failed to login to session state SQL server for user error?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I'm getting this error

"Failed to login to session state SQL server for user MyUserAccount"

The web.config has:

<system.web>
<sessionState
mode="SQLServer"
sqlConnectionString="Data Source=MyServer;UID=MyUserAccount;PWD=SomePassword"
cookieless="false"
timeout="120">
</sessionState>
</system.web>

And I granted this account db_datareader, db_datawriter, and db_owner to the
ASPState database and I still get this error. I'm using ASP.NET 2.0 and SQL
2005

Any ideas?
 
Back
Top