The SSO session object couldn't be retrieved from the database SSO session store.

SAML for ASP.NET
1

Using ADFS as the IdP, upon returning to the consume page, RecieveSSO is producing the following error.

“The SSO session object couldn’t be retrieved from the database SSO session store.”

Any ideas as to what might be causing this? I cannot find any references to this error in the documentation.

We are using the SSOSessions table as described in the documentation and records are being populated into the table. Other IdPs can authenticate just fine.

Ryan

2

Hi Ryan
This error occurs when the SELECT fails for whatever reason.
Please enable SAML trace and send the generated log file as an email attachment to our support email address mentioning your forum post.
http://www.componentspace.com/Forums/17/Enabing-SAML-Trace

3
[quote]
ComponentSpace - 7/28/2016
Hi Ryan
This error occurs when the SELECT fails for whatever reason.
Please enable SAML trace and send the generated log file as an email attachment to our support email address mentioning your forum post.
http://www.componentspace.com/Forums/17/Enabing-SAML-Trace

[/quote]

I also getting the same error, please find the attached log file.

SAMLController.SSOSessionStore = new ComponentSpace.SAML2.Data.DatabaseSSOSessionStore(); // Executing successfully but record is not inserted in to table. can read sessionid
if (!ComponentSpace.SAML2.SAMLServiceProvider.IsSSO(WebConfigurationManager.AppSettings["partnerIdP"].ToString())) // Getting Error In this line
{
ComponentSpace.SAML2.SAMLServiceProvider.InitiateSSO(Response, null, WebConfigurationManager.AppSettings["partnerIdP"].ToString());
}
4

The log includes:
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ‘eDocket’.
Please ensure the login credentials in your SQL server connection string are correct.

5
[quote]
ComponentSpace - 12/9/2018
The log includes:
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'eDocket'.
Please ensure the login credentials in your SQL server connection string are correct.
[/quote]

Thanks for the response, Issue got resolved
6

You’re welcome.