tMSSqlConnection works but Check connection on Metadata does not
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.