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
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
