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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
dstreun
Partner - Contributor III
Partner - Contributor III

Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy

So far okay: I can use a tMSSQLInput component. The Select statement in the SQL is executed correctly on the database and returns results. -
Problem: On pressing the "Guess Schema" button within the Properties of the tMSSQLInput component I get the error message "Can't connect to SOCKS proxy". (Besides: Same error also when testing the registered connection in the metadata)
==> Question: What is necessary to get a SOCKS proxy working:
a) for the SOCKS proxy server itself
b) on the network/firewall side (protocol, port etc)
0683p000009MGxb.png
I am using TOS 6.1.1 with jdk1.8.0_72 on a Windows 2012 Server

0683p000009MH4q.png

0683p000009MH3J.png

Proxy settings are working to download external modules:

0683p000009MH9G.png

Labels (2)
4 Replies
Anonymous
Not applicable

Hi,
We cannot repro your issue on our side. Is your socket proxy working well on other softwares?
Can you successfully connect to your mssql DB through client without using Talend Tool?
Best regards
Sabrina
dstreun
Partner - Contributor III
Partner - Contributor III
Author

Hi Sabrina
I even don't know if there is a socket proxy. (It's for the Swiss Government - IT org structure is quite complicated. Even simple questions take days to be answered and often need an official inquiry request...
But I can successfully connect to the MS SQL Database
  a) with other means than Talend (e.g. SQL Server Management Studio)
  b) but also with Talend.
All 3 things are on the same machine: MS SQL DB, Talend and SQL Server Management Studio.
Anonymous
Not applicable

Hi,
Does this issue repro on other build version?
Best regards
Sabrina
dstreun
Partner - Contributor III
Partner - Contributor III
Author

Sorry, in this case I am not allowed to install another build.
Could you, please, just tell me what happens on the network when pressing the "Guess Schema" button?