topic Metadata DB connection MS SQL server not able to connect in Talend Studio

Metadata DB connection MS SQL server not able to connect

NS1657544567 — Fri, 15 Nov 2024 22:45:22 GMT

New to Talend, install open source Studio, trying to create first db connection from Metadata->DB connection , have configured with DB connection information, also I think I have installed MS SS database JDBC driver and provided dependencies, however test connection fails, Where to look for below error message

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:1170)

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

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

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

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.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:834)

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

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

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

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

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

Re: Metadata DB connection MS SQL server not able to connect

Anonymous — Tue, 12 Jul 2022 03:20:34 GMT

Hello,

Regarding to the error log, the problem is that it's missing the mssql-jdbc driver

could you please try the workaround:

import the attach mssql-jdbc jar via studio-> Windows ->show view ->Talend->Modules view
then re-try?

Re: Metadata DB connection MS SQL server not able to connect

Anonymous — Tue, 12 Jul 2022 04:22:00 GMT

Hello,

If you've already installed the JDBC driver and it shows correctly as installed under the Talend Studio Modules, please let us know what version of Studio and the JDK version you are using. We assume that you don't install the correct jar file.

If so, please go to https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16 to determine the version you need that corresponds with your Java version.

Best regards

Sabrina

Re: Metadata DB connection MS SQL server not able to connect

NS1657544567 — Wed, 13 Jul 2022 16:14:24 GMT

Reinstalling JDK, pointing JAVA_HOME to new JDK location, reinstalled Talend studio with this JDK version , and finally added mssql-JDBC driver fixed the issue.

Re: Metadata DB connection MS SQL server not able to connect

Anonymous — Fri, 15 Jul 2022 03:27:50 GMT

Hello,

Great it is fixed. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina