Unable to Connect SQL Server from Talend

[ARasheed1670589738]

when connecting SQL serve in talend we are getting below error, In SQL server management studio same credential are working fine.

Connection failure. You must change the Database Settings.

  java.lang.RuntimeException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)

      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4208)

      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)

      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)

      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.lang.Thread.run(Thread.java:748)

  Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

      at java.net.URLClassLoader.findClass(URLClassLoader.java:381)

      at java.lang.ClassLoader.loadClass(ClassLoader.java:424)

      at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

      at java.lang.Class.forName0(Native Method)

      at java.lang.Class.forName(Class.java:348)

      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:124)

      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149)

[Anonymous]

It appears you are missing a required Java library for SQL Server. Is this a new installation of Talend? Have you downloaded all of the libraries that you should have been requested to download? Can you give a bit more detail about where/when you get this error?

[ARasheed1670589738]

we installed Talend 6 months back . Previously it was working. how can we check the required Java library files? when we are transferring data from oracle to SQL server, error is coming. If we are transferring oracle to mysql its working fine. Kindly advice. Please find the screenshot for ref