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.