SQL server 2012 driver

[janhess]

How do I install the sql server 2012 driver into Talend 5.0.2 or 5.3.1.

[_AnonymousUser]

Hi sanoussi,
Can you successfully connect to your sql server 2012 through client without using Talend Tool? Did you set up DB connection in metadata? If so, is there any more error message when you click "details" button?
Best regards
Sabrina

Hi Sabrina,
For my question i inform that i'm working on windows 10 and 64 bit system.
Thank you
sanoussi

[Anonymous]

Hi,

'BICORIS\mssql2012'.

Are you using a MSSQL named instance? Could you please show us your DB connection setting screenshot?
Best regards
Sabrina

[Anonymous]

is there any answer when create db connection to ms sql 2012 about this error ?
Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.sql.SQLException: Unknown server host name '.\SQLSERVER2012'.
      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(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
  Caused by: java.sql.SQLException: Unknown server host name 'EMERIO-AJI\SQLSERVER2012'.
      at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:427)
      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
  Caused by: java.net.UnknownHostException: EMERIO-AJI\SQLSERVER2012
      at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
      at java.net.PlainSocketImpl.connect(Unknown Source)
      at java.net.SocksSocketImpl.connect(Unknown Source)
      at java.net.Socket.connect(Unknown Source)
      at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
      at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
      at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
      ... 12 more