Unable to Connect SQL Server from Talend

ARasheed1670589738 — Fri, 15 Nov 2024 22:17:00 GMT

when connecting SQL serve in talend we are getting below error, In SQL server management studio same credential are working fine.

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.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.lang.Thread.run(Thread.java:748)

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

at java.net.URLClassLoader.findClass(URLClassLoader.java:381)

at java.lang.ClassLoader.loadClass(ClassLoader.java:424)

at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

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

at java.lang.Class.forName(Class.java:348)

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)

Re: Unable to Connect SQL Server from Talend

Anonymous — Fri, 09 Dec 2022 15:01:44 GMT

It appears you are missing a required Java library for SQL Server. Is this a new installation of Talend? Have you downloaded all of the libraries that you should have been requested to download? Can you give a bit more detail about where/when you get this error?

Re: Unable to Connect SQL Server from Talend

ARasheed1670589738 — Mon, 12 Dec 2022 04:20:31 GMT

we installed Talend 6 months back . Previously it was working. how can we check the required Java library files? when we are transferring data from oracle to SQL server, error is coming. If we are transferring oracle to mysql its working fine. Kindly advice. Please find the screenshot for ref

topic Unable to Connect SQL Server from Talend in Talend Studio

Unable to Connect SQL Server from Talend

Re: Unable to Connect SQL Server from Talend

Re: Unable to Connect SQL Server from Talend