I'm trying to use SQL 2008 for sessionstate, but keep getting the Login Failed exception...
[SqlException (0x80131904): Cannot open database "bSession-sd" requested by the login. The login failed. Login failed for user '********'.]
I've setup following web.config...
sqlConnectionString="data source=SQL01-NODE1; Initial Catalog=bSessions-sd; user id=********; password=********; Failover Partner=SQL01-NODE2;"
If I try connecting through Studion Management, with the same credentials, I'm granted full access.
The user account on the database is db_owner
What could possibly be the issue here?