topic tMSSqlConnection works but Check connection on Metadata does not in Talend Studio

tMSSqlConnection works but Check connection on Metadata does not

dstreun — Wed, 10 Feb 2016 15:31:51 GMT

Situation: I have built a simple job using a tMSSqlConnection and a tMSSqlInput component connected to a tLogRow component.
The job runs and outputs correct data! The tMSSqlConnection uses a Repository connection.
Problem: Despite the fact that the job runs there are 2 things that do not work:
1) When editing and checking the DB connection defined in the Metadata for usage with tMSSqlConnection => the check fails!
2) Pressing guess schema for a simple "Select ID, ... from <my_table>" fails for tMSSqlInput
I am working with TOS 6.1.1 and Java 1.8 (64bit) on a Windows 2012 Server.

Re: tMSSqlConnection works but Check connection on Metadata does not

Anonymous — Thu, 11 Feb 2016 07:03:39 GMT

Hello,
I've got the same issue! You can see my SQL Server settings in this post, maybe this could help...
Cheers,
Sylvain

Re: tMSSqlConnection works but Check connection on Metadata does not

dstreun — Thu, 11 Feb 2016 08:08:05 GMT

Hi Sylvain
Thanks but does not help.