SAP Knowledge Base Article - Preview

3194156 - "Unable to connect to data source. Check your connection details then try again" error occurs when creating an Import Data Connection to SQL Database in SAP Analytics Cloud (SAC)

Symptom

  • The following Error message occurs when creating an Import Data Connection to SQL Database in SAP Analytics Cloud (SAC): "Unable to connect to data source. Check your connection details then try again" 
  • From Tomcat logs we can see error similar to the following:"The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"."


Read more...

Environment

  • SAP Analytics Cloud
  • Microsoft SQL Server 2016
  • mssql-jdbc-10.2.0.jre8.jar

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Microsoft, SQL, Server, 2016, JDBC Driver, Import Data Connection, encryption , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.