Microsoft SQL connections

[kderose]

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. 

[Anonymous]

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

[kderose]

Yes we installed jtds-1.3.1

[Anonymous]

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

[kderose]

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.

[kderose]

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?

[Anonymous]

Hi,

Are you using JDK 1.8 or Jre 1.8?

Best regards

Sabrina

[kderose · Accepted solution]

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.

[Anonymous]

Hi,

Great this issue has been fixed.

Best regards

Sabrina

[Anonymous]

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