topic Re: Unable to connect to Microsoft SQL Server in Talend Studio

Unable to connect to Microsoft SQL Server

Anonymous — Tue, 20 Jun 2017 05:52:46 GMT

Hi,

I am Unable to connect to Microsoft SQL Server through Talend. It says mssql-jbdc jar missing. Although I have downloaded the JAR, where to put this to be able to connect to SQL server?

Re: Unable to connect to Microsoft SQL Server

Anonymous — Tue, 20 Jun 2017 07:59:57 GMT

Hello,

How did you install the driver file mssql-jdbc.jar?

After you have downloaded it, open the Module view ( go to Windows-->Show view-->Talend, and open it), and click the 'Import external jars' button to import it from your local disk.

Here is online document about:TalendHelpCenter:Installing external modules

Best regards

Sabrina

Re: Unable to connect to Microsoft SQL Server

Anonymous — Tue, 20 Jun 2017 08:14:49 GMT

Hi,

I did the same steps as you wrote.

After the 'Import External Jars' step, I refreshed the screen and below is the screenshot which I get. It is showing the JAR is not installed! So, how do I install it then?

Re: Unable to connect to Microsoft SQL Server

vapukov — Tue, 20 Jun 2017 10:15:38 GMT

double check name of driver file, including UpperLower cases, talend critical for name (and check only by exactly matched name)

often mistake

Different name, Like try to install joda-time-2.8.2.jar when You need joda-time-2.8.1.jar
Capital or lowercase laters, like MSsql-jdbc.jar

in Your case jar file name must be exactly mssql-jdbc.jar

Re: Unable to connect to Microsoft SQL Server

Anonymous — Tue, 20 Jun 2017 10:16:27 GMT

Any replies on this please?

Thanks

Pankaj

Re: Unable to connect to Microsoft SQL Server

vapukov — Tue, 20 Jun 2017 10:43:35 GMT

???

Re: Unable to connect to Microsoft SQL Server

Anonymous — Tue, 20 Jun 2017 11:09:30 GMT

Ya that just seemed to work out.. I changed the name of the jar to be exactly 'mssql-jdbc.jar' and it accepted it..

Thanks.

Re: Unable to connect to Microsoft SQL Server

Anonymous — Tue, 11 Jul 2017 06:01:04 GMT

well things seem to have been working well but now suddenly again I am facing a problem in connecting to my remote SQL Server database. Nothing has changed there except one or two restart of the server. It is giving me TCP/IP connection error athough the same is enabled!

I am attaching couple of screenshots for same.

Any suggestions please?

Re: Unable to connect to Microsoft SQL Server

Anonymous — Tue, 11 Jul 2017 08:34:55 GMT

Hello,

Is it network issue?

Have you already checked both IP address and port? It looks like you can connect to the server with the default port but the database driver uses often after the connect different ports for the peer-to-peer communication.Could you please check if your firewall disturb such routes?

Best regards

Sabrina

Re: Unable to connect to Microsoft SQL Server

Anonymous — Wed, 12 Jul 2017 13:05:39 GMT

Hi @xdshi,

From other machines, with SQL Studio Manager I am able to connect through same server and port!

Only from Talend I am not able to. Really surprising thing this is, but can't fathom why...

Re: Unable to connect to Microsoft SQL Server

Anonymous — Thu, 13 Jul 2017 03:30:20 GMT

Hello,

Could you please indicate on which build version you got this issue? Open source or subscription solution?

Best regards

Sabrina

Re: Unable to connect to Microsoft SQL Server

Anonymous — Thu, 13 Jul 2017 05:59:27 GMT

I am using Open Studio version 6.3. But the surprising thing is I was able to get the same connection around 3 weeks ago and now I am simply editing this connection and not getting connected to it!

Re: Unable to connect to Microsoft SQL Server

vapukov — Thu, 13 Jul 2017 11:23:49 GMT

SQL Server default port 1433 ... but sometime default settings - not work

by default if You open Server Configuration tools it do not have enabled all ip=addresses on server, and have empty port number

I meet many cases, when this - not work from 3rd party tools (Microsoft could continue work)

You just change manually all used interfaces to Enable and all ports to 1433

Re: Unable to connect to Microsoft SQL Server

Anonymous — Fri, 24 Aug 2018 17:52:29 GMT

I am getting same issue like you.are you able to solve...

Re: Unable to connect to Microsoft SQL Server

Anonymous — Mon, 27 Aug 2018 03:19:55 GMT

Hello,

Is the solution in this topic OK with you? Could you please give us more information about your issue?

Best regards

Sabrina

Re: Unable to connect to Microsoft SQL Server

LI1 — Tue, 02 Oct 2018 15:42:39 GMT

The issue I've found is one SQL Server DB is on 2014 - vs all the rest I could successfully could connect to.

downloaded this new driver: https://www.microsoft.com/en-gb/download/details.aspx?id=11774

then used on sqlworkbench - worked a treat.

But now need to remember how to replace all the old JDBC sql server jar with this new one and re-test - currently unsuccessful.

Is there a nice way to do this?

Re: Unable to connect to Microsoft SQL Server

Anonymous — Tue, 23 Oct 2018 08:08:40 GMT

Hello,

Could you please try to follow these steps to update your jar file?
1) Make a backup of your old JDBC sql server jar

2) Rename you new JDBC sql server jar to old JDBC sql server jar within Studio

3) Rebuild/Re-run job

Let us know if it works.