SQL DataStore Error Retrieving Contact Info

    Applies to:
  • Legacy SecureAuth IdP
Deployment model:
  • On Premises
  • SecureAuth IdP Version affected: All
    When trying to log into a realm that uses a SQL Datastore, the users see "Error Retrieving Contact info"

    The warning log shows "SqlProfileProvider.GetPropertyValues: for user: username Exception: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not posses a common algorithm.)"


    The SQL Server is old and does not support modern TLS protocols


    The correct way to resolve this issue is to upgrade your SQL Server to a version that supports TLS 1.2

    This Microsoft article covers the topic https://support.microsoft.com/en-gb/help/3135244/tls-1-2-support-for-microsoft-sql-server

    If you need a short term fix, it is possible but not recommended to re-enable older versions of TLS on the IdP. Enabling TLS 1.0 would allow this to work.



    SecureAuth Knowledge Base Articles provide information based on specific use cases and may not apply to all appliances or configurations. Be advised that these instructions could cause harm to the environment if not followed correctly or if they do not apply to the current use case.
    Customers are responsible for their own due diligence prior to utilizing this information and agree that SecureAuth is not liable for any issues caused by misconfiguration directly or indirectly related to SecureAuth products.

    0 out of 0 found this helpful



    Please sign in to leave a comment.