core.error.code.DYNAMIC_CLASS_LOAD_FAILURE - Failed to dynamically load driver and connect : com.microsoft.sqlserver.jdbc.SQLServerDriver
this is my connection string:
Any idea what's is going wrong and how to fix this?
The steps that worked for us were
1. Download the mssql JDBC connector from microsoft's page
We got the Microsoft JDBC Driver 7.4 (JRE 8, 11, 12) - download the *tar.gz*, NOT the exe
2. Unzip the driver. You should get a file named mssql-jdbc-7.4.1.jre8.jar among others. copy this one to the TOMCAT_HOME/lib folder
in our case it was:
# cp mssql-jdbc-7.4.1.jre8.jar /usr/local/qdc/apache-tomcat-7.0.94/lib/
3. With the file copied, shutdown and then start tomcat (don't simply "restart" it. Do this two-step procedure)
Test again from the Catalyst UI. It should work fine now.
For whom it may be useful - I have been struggling whit this error for 2+ hours and finaly managed by only use of SQL Server native user instead of AD one... so, if you use domain users just consider this choice.
thank you very much this solution worked for me too. Install mssql-jdbc-9.2.1.jre8.jar
cp -R /tmp/mssql-jdbc-9.2.1.jre8.jar /usr/local/qdc/apache-tomcat-9.0.38/lib/
Start Tomcat manually
(qdc) $ cd <tomcat home>
Tomcat can be manually stopped at any time
(qdc) # cd <tomcat home>
(qdc) # ./bin/shutdown.sh