Unable to connect to Microsoft SQL Server

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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?

[vapukov · Accepted solution]

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

[Anonymous]

Any replies on this please?

Thanks

Pankaj

[vapukov]

???

[Anonymous]

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.

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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