Microsoft SQL connections

Highlighted
Five Stars

Microsoft SQL connections

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. 


Accepted Solutions
Five Stars

Re: Microsoft SQL connections

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.

View solution in original post


All Replies
Moderator

Re: Microsoft SQL connections

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Microsoft SQL connections

Yes we installed jtds-1.3.1

Modules.png

Moderator

Re: Microsoft SQL connections

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Microsoft SQL connections

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.

Five Stars

Re: Microsoft SQL connections

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?

Moderator

Re: Microsoft SQL connections

Hi,

Are you using JDK 1.8 or Jre 1.8?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Microsoft SQL connections

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.

View solution in original post

Moderator

Re: Microsoft SQL connections

Hi,

Great this issue has been fixed.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Microsoft SQL connections

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog