Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dstreun
Partner - Contributor III
Partner - Contributor III

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.
Labels (3)
2 Replies
Anonymous
Not applicable

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

Hi Sylvain
Thanks but does not help.