Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

Dave

unread,
Apr 15, 2008, 2:17:27 PM4/15/08
to
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?

Dave

unread,
Apr 15, 2008, 2:37:00 PM4/15/08
to
fixed it, re-checked password
0 new messages