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

Creating a connection to a SQL Database, the following error appears:

• SERVER_ERROR_500
  The database driver is misconfigured. Contact your SAP Analytics Cloud agent administrator.
• SERVER_ERROR_500
  The database driver is misconfigured. Contact your SAP BusinessObjects Cloud agent administrator. 

In the traces area of the application you will find the following stack:

• Message: Exception@/sap/fpa/services/core/system/Exception.xsjslib:106
  ExceptionCSAgent@/sap/fpa/services/dm/agent/cs/CSAgent.xsjslib:22
  @/sap/fpa/services/dm/agent/cs/CSAgent.xsjslib:96
  @/sap/fpa/services/dm/agent/cs/CSAgent.xsjslib:108
  @/sap/fpa/services/dm/RestDataIntegration.xsjslib:155
  handleRequest@/sap/fpa/services/GetResponse.xsjs:304
  @/sap/fpa/services/GetResponse.xsjs:343

If you examine the Tomcat log file: stderr.log you will find the following line:

• SEVERE [http-nio-8080-exec-7] com.sap.fpa.cloud.internal.DAException.logException ERROR_DRIVER_NOT_CONFIGURED

• SAP Analytics Cloud

1. Configure SQL Database access as indicated in SAP Analytics Cloud User's Guide.
2. Configure the Driverconfig.properties file with an entry for the SQL database, for example SQL server:

• MS SQL Server 2014="C:\SACBOC_Agent_JDBC_Driver\sqljdbc_6.0\enu\sqljdbc4.jar" or "C:\Program Files\Apache Software Foundation\Tomcat 9.0\sqljdbc.jar"

• The double quotes characters are not necessary and are read as part of the path.
• The path to the library file  may not be correct or is not accessible due to security reasons.

Remove the double quote characters from the path to the JAR file and confirm the path is correct / accessible:

• MS SQL Server 2014=C:\SAC_Agent_JDBC_Driver\sqljdbc_6.0\enu\sqljdbc4.jar
  OR
• MS SQL Server 2014=C:\Program Files\Apache Software Foundation\Tomcat 9.0\sqljdbc.jar

• 2358097 - SAP Analytics Cloud connecting to on-premise data *** Master KBA ***
• 2557071 - Error: The database driver is misconfigured on SAP Analytics Cloud when creating a SQL connection
• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• Microsoft JDBC Driver 6.2 for SQL Server

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.

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, SQL connection, SQL driver, database driver is misconfigured, , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem