Metadata DB connection MS SQL server not able to connect

[NS1657544567]

New to Talend, install open source Studio, trying to create first db connection from Metadata->DB connection , have configured with DB connection information, also I think I have installed MS SS database JDBC driver and provided dependencies, however test connection fails, Where to look for below error message

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:1170)

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

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

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

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.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.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

   at java.base/java.lang.Thread.run(Thread.java:834)

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

   at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:471)

   at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:588)

   at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)

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

   at java.base/java.lang.Class.forName(Class.java:398)

   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)

   ... 9 more

[Anonymous]

Hello,

Regarding to the error log, the problem is that it's missing the mssql-jdbc driver

could you please try the workaround:

1. import the attach mssql-jdbc jar via studio-> Windows ->show view ->Talend->Modules view
2. then re-try?

[Anonymous]

Hello,

If you've already installed the JDBC driver and it shows correctly as installed under the Talend Studio Modules, please let us know what version of Studio and the JDK version you are using. We assume that you don't install the correct jar file.

If so, please go to https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matri... to determine the version you need that corresponds with your Java version.

Best regards

Sabrina

[NS1657544567 · Accepted solution]

Reinstalling JDK, pointing JAVA_HOME to new JDK location, reinstalled Talend studio with this JDK version , and finally added mssql-JDBC driver fixed the issue.

[Anonymous]

Hello,

Great it is fixed. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina