Getting error to connect to Microsoft SQL Server Database

[Anonymous]

I am trying to create a DB connection with Microsoft SQL Server Database. But I am getting the error. can you suggest?

[Anonymous]

Refering to my above question, If I select the DB version as Microsoft, then I get the follwowing error:

Also I have downloaded the sqljdbc.jar. But where should I put it to get rid of the error?

[Anonymous · Accepted solution]

Hello
You need to download and install the driver file mssql-jdbc.jar in order to finish
creating MSSQL server metadata or use MSSQL server components in studio. After you have downloaded it, open the Module view (if it does not appear, go to Windows-->Show view-->Talend, and open it), and click the 'Import external jars' button to import it from your local disk.

Regards
Shong

[Anonymous]

OK, I do exactly the same. But still I get the same error.

Also I am using Talend 6.3 for Data Integration and I am using Java8. So see the screenshot and suggest.

[Anonymous]

I am also facing similar issue, i installed the sqljdbc41.jar jar file for mssqlserver database but still facing issue in connecting to the DB connection in metadata

[Anonymous]

@ppp_rrr, I think you have resolved the problem after you rename the jar file to mssql-jdbc.jar and install it to studio.
@shobhitj, please install the right jar file according to the DB version you select.

[Anonymous]

Ya exactly, just make sure you have the exact JAR file required(same name) and your problem should be resolved.

[Anonymous]

Thanks, changing the jar file name to mssql-jdbc.jar and placing in right java version directory helped. Able to connect now.Thanks @shong & @ppp_rrr

[Anonymous]

hi i am getting same error bro,can you please how you did that? after replacing file name where we kept that jar file?please help me out