topic Error establishing socket to host and port: in Talend Studio https://community.qlik.com/t5/Talend-Studio/Error-establishing-socket-to-host-and-port/m-p/2210610#M8960 <P>Hi&nbsp;<BR />I am using tJDBCConnection component to eastablish connection.<BR />All the credentials are authentic and valid.<BR />Most of the time it works and sometime it doesn't.<BR /><BR />Kindly help me identify why do I have this error sometimes.<BR /><BR />Error establishing socket to host and port:&nbsp; Reason: Connection refused: connect<BR /><BR /><BR /></P> Wed, 05 Dec 2018 05:00:52 GMT rohitpatil1993 2018-12-05T05:00:52Z Error establishing socket to host and port: https://community.qlik.com/t5/Talend-Studio/Error-establishing-socket-to-host-and-port/m-p/2210610#M8960 <P>Hi&nbsp;<BR />I am using tJDBCConnection component to eastablish connection.<BR />All the credentials are authentic and valid.<BR />Most of the time it works and sometime it doesn't.<BR /><BR />Kindly help me identify why do I have this error sometimes.<BR /><BR />Error establishing socket to host and port:&nbsp; Reason: Connection refused: connect<BR /><BR /><BR /></P> Wed, 05 Dec 2018 05:00:52 GMT https://community.qlik.com/t5/Talend-Studio/Error-establishing-socket-to-host-and-port/m-p/2210610#M8960 rohitpatil1993 2018-12-05T05:00:52Z Re: Error establishing socket to host and port: https://community.qlik.com/t5/Talend-Studio/Error-establishing-socket-to-host-and-port/m-p/2210611#M8961 <P>Hello,</P> <P>&nbsp;Which DB connection are you try to set up? Sql Server? What's yoru port? 1400 or 1433? More information will be helpful for us to address your issue.</P> <P>Best regards</P> <P>Sabrina</P> <P>&nbsp;</P> Wed, 05 Dec 2018 07:17:14 GMT https://community.qlik.com/t5/Talend-Studio/Error-establishing-socket-to-host-and-port/m-p/2210611#M8961 Anonymous 2018-12-05T07:17:14Z Re: Error establishing socket to host and port: https://community.qlik.com/t5/Talend-Studio/Error-establishing-socket-to-host-and-port/m-p/2210612#M8962 Hi Sabrina <BR />The issue is resolved now. <BR />Thanks for the reply anyway <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> Wed, 05 Dec 2018 08:09:18 GMT https://community.qlik.com/t5/Talend-Studio/Error-establishing-socket-to-host-and-port/m-p/2210612#M8962 rohitpatil1993 2018-12-05T08:09:18Z