Having trouble installing Microsoft JDBC driver

[MarkM1]

I am using TOS DI version 7.3

I am able to connect to SQL Server with jTDS, but I want to use the Microsoft driver. I downloaded the most recent Microsoft jdbc driver, and installed it by clicking the Jar button on the Talend dialog. But when I try Test Connection I get:

Connection failure. You must change the Database Settings.

 java.lang.RuntimeException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

   at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4208)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)

   at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)

   at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)

   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

   at java.base/java.lang.Thread.run(Thread.java:829)

 Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

   at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476)

   at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:589)

   at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)

   at java.base/java.lang.Class.forName0(Native Method)

   at java.base/java.lang.Class.forName(Class.java:398)

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:124)

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149)

   ... 9 more

[Ruchi_27]

Hello,

You need to download the Microsoft JDBC Driver for SQL Server on Microsoft Download Center, unpack the downloaded zip file, choose a jar in the unzipped folder based on your JRE version, rename the jar to mssql-jdbc.jar and install it manually.

If the above was correctly performed please try below:

> Uninstall the external module for MSSQL by deleting the following folder:

\studio\configuration\.m2\repository\org\talend\libraries\mssql-jdbc

-------------------------

>Once you delete this, the next time you login to Talend Studio, you can install the module externally.

OR

> Use the tLibraryLoad component to import the jar "mssql-jdbc-X.X.Xjar"

I hope this helps!

[Anonymous · Accepted solution]

Hi

It seems you don't use a right driver version that matches your JRE version, as @Ruchi Singh​ suggested, try to download the right driver version and install it again.

BTW, I installed the latest driver version mssql-jdbc-11.2.0.jre11.jar in TOS for DI 8.0.1 and it works.

Regards

Shong