topic Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy in Talend Studio https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343233#M111014 <P>So far okay: I can use a tMSSQLInput component. The Select statement in the SQL is executed correctly on the database and returns results. - <BR />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)<BR />==&gt; Question: What is necessary to get a SOCKS proxy working:<BR />a) for the SOCKS proxy server itself<BR />b) on the network/firewall side (protocol, port etc)<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGxb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134792i9DF22A9B6F01FD77/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGxb.png" alt="0683p000009MGxb.png" /></span><BR />I am using TOS 6.1.1 with jdk1.8.0_72 on a Windows 2012 Server <BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH4q.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136888i14D6CA255DA0BD5B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH4q.png" alt="0683p000009MH4q.png" /></span><BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH3J.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152767i1647A3D0DD26A90E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH3J.png" alt="0683p000009MH3J.png" /></span><BR /><BR />Proxy settings are working to download external modules:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH9G.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156923i11983BF0949E8B21/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH9G.png" alt="0683p000009MH9G.png" /></span></P> Thu, 18 Feb 2016 14:59:44 GMT dstreun 2016-02-18T14:59:44Z Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343233#M111014 <P>So far okay: I can use a tMSSQLInput component. The Select statement in the SQL is executed correctly on the database and returns results. - <BR />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)<BR />==&gt; Question: What is necessary to get a SOCKS proxy working:<BR />a) for the SOCKS proxy server itself<BR />b) on the network/firewall side (protocol, port etc)<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MGxb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134792i9DF22A9B6F01FD77/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MGxb.png" alt="0683p000009MGxb.png" /></span><BR />I am using TOS 6.1.1 with jdk1.8.0_72 on a Windows 2012 Server <BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH4q.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136888i14D6CA255DA0BD5B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH4q.png" alt="0683p000009MH4q.png" /></span><BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH3J.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152767i1647A3D0DD26A90E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH3J.png" alt="0683p000009MH3J.png" /></span><BR /><BR />Proxy settings are working to download external modules:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MH9G.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156923i11983BF0949E8B21/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MH9G.png" alt="0683p000009MH9G.png" /></span></P> Thu, 18 Feb 2016 14:59:44 GMT https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343233#M111014 dstreun 2016-02-18T14:59:44Z Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343234#M111015 Hi,<BR />We cannot repro your issue on our side. Is your socket proxy working well on other softwares?<BR />Can you successfully connect to your mssql DB through client without using Talend Tool?<BR />Best regards<BR />Sabrina Fri, 19 Feb 2016 03:10:02 GMT https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343234#M111015 Anonymous 2016-02-19T03:10:02Z Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343235#M111016 Hi Sabrina<BR />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... <BR />But I can successfully connect to the MS SQL Database <BR />&nbsp; a) with other means than Talend (e.g. SQL Server Management Studio) <BR />&nbsp; b) but also with Talend.<BR />All 3 things are on the same machine: MS SQL DB, Talend and SQL Server Management Studio. Fri, 19 Feb 2016 08:13:00 GMT https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343235#M111016 dstreun 2016-02-19T08:13:00Z Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343236#M111017 Hi,<BR />Does this issue repro on other build version?<BR />Best regards<BR />Sabrina Fri, 26 Feb 2016 07:44:45 GMT https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343236#M111017 Anonymous 2016-02-26T07:44:45Z Re: Guess Schema for tMSSQLInput: Can't connect to SOCKS proxy https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343237#M111018 Sorry, in this case I am not allowed to install another build. <BR />Could you, please, just tell me what happens on the network when pressing the "Guess Schema" button? Mon, 07 Mar 2016 10:58:50 GMT https://community.qlik.com/t5/Talend-Studio/Guess-Schema-for-tMSSQLInput-Can-t-connect-to-SOCKS-proxy/m-p/2343237#M111018 dstreun 2016-03-07T10:58:50Z