SAP Knowledge Base Article - Public

3426750 - Error: "Unable to connect to data source. Check your connection details then try again" occurs when creating an Import Data Connection to MS SQL 2014 Database in SAP Analytics Cloud

Symptom

  • "Unable to connect to data source. Check your connection details then try again" error occurs when creating an Import Data Connection to MS SQL 2014 Database in SAC.
  • Errors {ERROR_INVALID_CONNECTION_INFO} and {The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Certificates do not conform to algorithm constraints"} are visible in the Catalina logs.

Environment

  • SAP Analytics Cloud
  • OS version: "SUSE Linux Enterprise Server 15 SP4" 

Reproducing the Issue

  1. Login into SAC.
  2. Go to connections.
  3. Create an Import Data Connection to SQL Database.
  4. Select MS SQL 2014.
  5. Fill the necessary details and click on create
    >>"Unable to connect to data source. Check your connection details then try again" error occurs.

Cause

This issue is currently under investigation by the development team.

Resolution

This issue is currently under investigation by the development team.

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, sapanalyticscloud, sap analytical cloud, database, display , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0