<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Assure connection to MS SQL Server was successful or not in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Assure-connection-to-MS-SQL-Server-was-successful-or-not/m-p/2252015#M35784</link>
    <description>&lt;P&gt;Hi there,&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I'm using Talend DI 6.4.0, in which I've installed mssql-jdbc drivers to connect to connect to MS SQL server. But after running job It is not getting connected. Below are the screenshots :&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-06-05 at 3.35.58 PM.png" style="width: 857px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LusY.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/151313iBB49C768E32EF86B/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LusY.png" alt="0683p000009LusY.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-06-05 at 4.22.08 PM.png" style="width: 772px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lusd.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/151450i47C62D2C1A3C1070/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009Lusd.png" alt="0683p000009Lusd.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;What might be going wrong ?&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;STRONG&gt;UPDATE :&lt;/STRONG&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I've tried changing port to default i.e. 1433&amp;nbsp;and the&amp;nbsp;error has gone. Here is the screenshot :&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-06-05 at 4.55.14 PM.png" style="width: 521px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lukk.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/156935iE3027B87C9F9480D/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009Lukk.png" alt="0683p000009Lukk.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;But how can I assure if connection was successful or not ?&lt;/P&gt;</description>
    <pubDate>Mon, 05 Jun 2017 11:58:42 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2017-06-05T11:58:42Z</dc:date>
    <item>
      <title>Assure connection to MS SQL Server was successful or not</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Assure-connection-to-MS-SQL-Server-was-successful-or-not/m-p/2252015#M35784</link>
      <description>&lt;P&gt;Hi there,&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I'm using Talend DI 6.4.0, in which I've installed mssql-jdbc drivers to connect to connect to MS SQL server. But after running job It is not getting connected. Below are the screenshots :&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-06-05 at 3.35.58 PM.png" style="width: 857px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LusY.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/151313iBB49C768E32EF86B/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LusY.png" alt="0683p000009LusY.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-06-05 at 4.22.08 PM.png" style="width: 772px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lusd.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/151450i47C62D2C1A3C1070/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009Lusd.png" alt="0683p000009Lusd.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;What might be going wrong ?&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;STRONG&gt;UPDATE :&lt;/STRONG&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I've tried changing port to default i.e. 1433&amp;nbsp;and the&amp;nbsp;error has gone. Here is the screenshot :&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-06-05 at 4.55.14 PM.png" style="width: 521px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lukk.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/156935iE3027B87C9F9480D/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009Lukk.png" alt="0683p000009Lukk.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;But how can I assure if connection was successful or not ?&lt;/P&gt;</description>
      <pubDate>Mon, 05 Jun 2017 11:58:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Assure-connection-to-MS-SQL-Server-was-successful-or-not/m-p/2252015#M35784</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-06-05T11:58:42Z</dc:date>
    </item>
    <item>
      <title>Re: Assure connection to MS SQL Server was successful or not</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Assure-connection-to-MS-SQL-Server-was-successful-or-not/m-p/2252016#M35785</link>
      <description>Hi,&lt;BR /&gt;Usually, if you have no error, then... there is no error, but you can be sure that in case of, the next db component will fail if not connected yet.</description>
      <pubDate>Mon, 05 Jun 2017 20:10:03 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Assure-connection-to-MS-SQL-Server-was-successful-or-not/m-p/2252016#M35785</guid>
      <dc:creator>TRF</dc:creator>
      <dc:date>2017-06-05T20:10:03Z</dc:date>
    </item>
  </channel>
</rss>

