connection mssql database

_AnonymousUser — Thu, 05 Jan 2017 08:58:22 GMT

Morning,
i cannot connect on mssql database in talend.
when i put the parameter connection. i have this error
Exception in component tMSSqlInput_2
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:654)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at talendpickupprojects.j_flx2091_pid_crm_setreferentieltransporteur_0_1.J_FLX2091_PID_CRM_SetReferentielTransporteur.tMSSqlInput_2Process(J_FLX2091_PID_CRM_SetReferentielTransporteur.java:2677)
at talendpickupprojects.j_flx2091_pid_crm_setreferentieltransporteur_0_1.J_FLX2091_PID_CRM_SetReferentielTransporteur.tLog4J_8Process(J_FLX2091_PID_CRM_SetReferentielTransporteur.java:1402)
at talendpickupprojects.j_flx2091_pid_crm_setreferentieltransporteur_0_1.J_FLX2091_PID_CRM_SetReferentielTransporteur.runJobInTOS(J_FLX2091_PID_CRM_SetReferentielTransporteur.java:12013)
at talendpickupprojects.j_flx2091_pid_crm_setreferentieltransporteur_0_1.J_FLX2091_PID_CRM_SetReferentielTransporteur.main(J_FLX2091_PID_CRM_SetReferentielTransporteur.java:11633)
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1963)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:617)
... 8 more
Exception in component tMSSqlInput_4
java.sql.SQLException: The syntax of the connection URL 'jdbc:jtds:sqlserver://:1433;appName=TALENDPICKUPPROJECTS;noDatetimeStringSync=true' is invalid.
at net.sourceforge.jtds.jdbc.Driver.setupConnectProperties(Driver.java:242)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at talendpickupprojects.j_flx2091_pid_crm_setreferentieltransporteur_0_1.J_FLX2091_PID_CRM_SetReferentielTransporteur.tMSSqlInput_4Process(J_FLX2091_PID_CRM_SetReferentielTransporteur.java:9745)
thank you for your help

Re: connection mssql database

Anonymous — Fri, 06 Jan 2017 02:42:21 GMT

Hi,

Exception in component tMSSqlInput_4
java.sql.SQLException: The syntax of the connection URL 'jdbc:jtds:sqlserver://:1433;appName=TALENDPICKUPPROJECTS;noDatetimeStringSync=true' is invalid.

Can you successfully connect your MSSql server DB through client without using talend tool?
Best regards
Sabrina

topic connection mssql database in Talend Studio

connection mssql database

Re: connection mssql database