Six Stars

Assure connection to MS SQL Server was successful or not

Hi there,

 

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 :

 

Screen Shot 2017-06-05 at 3.35.58 PM.pngScreen Shot 2017-06-05 at 4.22.08 PM.png 

 

What might be going wrong ?

 

UPDATE :

 

I've tried changing port to default i.e. 1433 and the error has gone. Here is the screenshot : 

 

Screen Shot 2017-06-05 at 4.55.14 PM.png

 

But how can I assure if connection was successful or not ?

  • Data Integration
Tags (1)
1 REPLY
Seven Stars TRF
Seven Stars

Re: Assure connection to MS SQL Server was successful or not

Hi,
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.

TRF