topic Re: Microsoft SQL connections in Installing and Upgrading

Microsoft SQL connections

kderose — Sat, 16 Nov 2024 09:52:02 GMT

We setup a new server and installed Open Studio for Data Integration 6.3.1. We exported our old projects from DI 5.6 on a separate machine. We were able to import the projects into DI 6.3 but when we attempt to connect to any of the old SQL metadata connections we receive an error when checking the connection.

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:195)
	at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)

We have attempted with login/password and without ,with JTDS and Microsoft. We have copied the file ntlmauth.dll into all the usual places. We have added the JAVA_HOME and set the paths to jre1.8.0_101\bin. Any thoughts or hints would be appreciated.

Re: Microsoft SQL connections

Anonymous — Wed, 26 Apr 2017 09:36:29 GMT

Hi,

From your error message, there is a missing jar issue(jtds-xxx.jar).

Have you already installed the external required jar file for Data Integration 6.3.1?

Best regards

Sabrina

Re: Microsoft SQL connections

kderose — Wed, 26 Apr 2017 12:31:28 GMT

Yes we installed jtds-1.3.1

Re: Microsoft SQL connections

Anonymous — Thu, 27 Apr 2017 10:15:20 GMT

Hi,

Have you tried to restart your studio after install the external jar file(jtds-1.3.1)?

Did you install proper - ntlmauth.dll? (32/64 bit)?

Best regards

Sabrina

Re: Microsoft SQL connections

kderose — Thu, 27 Apr 2017 18:09:50 GMT

Yes, We restarted Studio and we re-copied the ntlmauth.dll just to make sure we chose the correct version. We are still getting the same error.

Re: Microsoft SQL connections

kderose — Mon, 01 May 2017 13:10:41 GMT

I tried downloading and installing all the modules available but we are still getting the same error on our SQL DB connections. Is there anything else we can attempt before we uninstall?

Re: Microsoft SQL connections

Anonymous — Wed, 03 May 2017 09:38:15 GMT

Hi,

Are you using JDK 1.8 or Jre 1.8?

Best regards

Sabrina

Re: Microsoft SQL connections

kderose — Thu, 04 May 2017 19:03:46 GMT

We uninstalled and re-installed TOS, then installed all the modules again. After copying the ntlmauth.dll into the usual folders we were able to get the Microsoft SQL connections working.

Re: Microsoft SQL connections

Anonymous — Fri, 05 May 2017 08:59:33 GMT

Hi,

Great this issue has been fixed.

Best regards

Sabrina

Re: Microsoft SQL connections

Anonymous — Fri, 16 Mar 2018 11:27:09 GMT

Even iam facing same issue - Connection failure. You must change the Database Settings

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: Unknown server host name 'GADC-SQLP020.na.pg.com\DRNAP2002'.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2638)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.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.sql.SQLException: Unknown server host name 'GADC-SQLP020.na.pg.com\DRNAP2002'.
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:427)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more
Caused by: java.net.UnknownHostException: GADC-SQLP020.na.pg.com\DRNAP2002
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
... 12 more