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
- Login to SAC.
- Go to Connections, and then click on the "+" icon.
- Choose SQL Databases.
- Select a location, and then MS SQL Server 2012.
- 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
- Add MS SQL Server 2014=<path_to_jdbc_driver> in the .properties file.
- 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