Connectivity issue with Microsoft SQL Server

Anonymous — Sat, 16 Nov 2024 02:51:27 GMT

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:209)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1133)
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:4207)
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(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:125)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:150)
... 9 more

I'm getting the aforementioned error even after placing the ntlmauth.dl file in the bin folder of the Java directory. I'm also using the Open Source JTDS as my DB version. Please help me resolve this issue.

Re: Connectivity issue with Microsoft SQL Server

billimmer — Fri, 27 Mar 2020 18:27:50 GMT

Don't know but here is what I have for my Microsoft SQL Server connection:

DB Type: Microsoft SQL Server

Db Version: Open source JTDS

String of Connection: jdbc:jtds:sqlserver://myserver:1433/mydatabasename;

Password: ************************

Server: myserver

Port: 1433

Database: mydatabasename

Schema: myschema

topic Connectivity issue with Microsoft SQL Server in Talend Studio

Connectivity issue with Microsoft SQL Server

Re: Connectivity issue with Microsoft SQL Server