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.