SAP Knowledge Base Article - Public

3339240 - Error: "The database driver is misconfigured. Contact your SAP Analytics Cloud agent administrator." when creating an MS SQL Server 2012 connection in SAC.

Symptom

When trying to create a new MS SQL Server version 2012 connection the below error occurs:

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

Environment

  • SAP Analytics Cloud.
  • Microsoft SQL server 2012 db.

Reproducing the Issue

  1. Login to SAC.
  2. Go to Connections, and then click on the "+" icon.
  3. Choose SQL Databases.
  4. Select a location, and then MS SQL Server 2012.
  5. Fill the necessary details and click OK
    >> Notice the error: "The database driver is misconfigured. Contact your SAP Analytics Cloud agent administrator."

Cause

Needed extra configuration

Resolution

  1. Add MS SQL Server 2014=<path_to_jdbc_driver> in the .properties file.
  2. In SAC choose MS SQL Server 2012.

See Also

Refer to this link for more information about supported JDBC versions, under the section SQL version compatibility: https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?source=recommendations&view=sql-server-ver16#sql-version-compatibility

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SQL, version, agent, SAC Agent Kit , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0