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,

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

Best regards

Sabrina

[Anonymous]

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!

[vapukov]

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

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[LI1]

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?

[Anonymous]

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.