Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Talend Data QUality & MS SQL SERVER 2012

Hi every body,
do you know when Talend Data QUality (Profiling) will support MS SQL SERVER 2012 ?
what is the difference between the connectors MS SQLSERVER & MS SQLSERVER 2005,2008 ? (if there are any)
Thx,

Labels (3)
11 Replies
Anonymous
Not applicable
Author

Hello,
I have issue with the connection to ms sql server 2014, Is their a problem with this version of SQL server 2014?
Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.sql.SQLException: Login failed for user 'elie'.
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.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:745)
  Caused by: java.sql.SQLException: Login failed for user 'elie'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
      at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)
      at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:371)
      at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
      ... 9 more
Anonymous
Not applicable
Author

Hi elio_bn,
So far, ms sql server 2014 is not list on supported DB version.
Please take a look at documents about: TalendHelpCenter0683p000009M9p6.pngupported+systems+databases+and+business+applications+by+Talend+components and TalendHelpCenter0683p000009M9p6.pngupported+databases+for+profiling+data.
From this error message, this is a login failure message.
Can you use  user 'elie' to connect your MSSql DB through client without using Talend tool successfully?
Best regards
Sabrina