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. 

  • Talend Studio
1 ACCEPTED SOLUTION

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.

8 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.

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.