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

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

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

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."

Needed extra configuration

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

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

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