SAP Knowledge Base Article - Public

2557071 - Error: The database driver is misconfigured in SAP Analytics Cloud when creating a SQL connection

Symptom

Getting below message when trying to create a SQL connection in SAP Analytics Cloud:

"The database driver is misconfigured. Contact your SAP Analytics Cloud agent administrator."

Environment

  • SAP Analytics Cloud
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2008

Reproducing the Issue

After verifying that SAP Cloud Connector and SAP Analytics Cloud Agent are working properly:

  1. Follow the steps in the guide - https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/0d5ffbb6951b45778c1a90ffd0114f04.html
  2. Fill the connection details fields.
  3. Click the "Create" button and the mentioned error appears

Cause

The MS SQL driver is obsolete.

Resolution

Download and configure the latest available MS SQL Server JDBC driver from the Microsoft Website. At the time of writing this article, the latest is version 6.2.

If using the latest driver, as a workaround, change the driverconfig.properties (which the Environment variable "SAP_CLOUD_AGENT_PROPERTIES_PATH" points to) file to point to a later version of MS SQL Server.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating facility at the top right-hand corner of this article.
Thank you.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, SAP Analytics Cloud, SQL connection, SQL driver, database driver is misconfigured, , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0