With the community edition of Pentaho Data Integration - Kettle 5.0.1 () I could connect to my MS SQL Server 2014 database with no issues, choosing MS SQL Serever and then Native (JDBC) from tools -? Wizard ->create database connection. I have now upgraded to the latest 5.4 version, and I can no longer connect. The error I get is the following. Any suggestions on how to fix this?

What I find confusing is that I can't find a way to tell Pentaho where excatly the jdbc drivers are. I downloaded Microsoft's JDBC drivers (), but how do I get Pentaho to use them?

Jira Software. Project and issue. Confluence Database Setup Fails for MS SQL Server with Connection Refused. At net.sourceforge.jtds.jdbc.Driver.connect.

This means that you either did not register jTDS with the. (Login failed). But because jTDS is expecting a. Trying to connect to SQL Server 2012. Login failed for user 'sa'. At net.sourceforge.jtds.jdbc.SQLDiagnostic. At net.sourceforge.jtds.jdbc.Driver.connect. Pentaho data integration: jdbc connection to MS. (using class net.sourceforge.jtds.jdbc.Driver) I/O Error: SSO Failed. At net.sourceforge.jtds.jdbc.Driver.

I copied the file sqljdbc42.jar to c: Pentaho lib but to no avail. I also tried using it in the 'generic database' option but, again, to no avail. Error connecting to database [c]: org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver) I/O Error: SSO Failed: Native SSPI library not loaded.

Check the java. Wargame Red Dragon Setup.exe. library.path system property. Org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver) I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

I fixed this by copying the ntlmauth.dll file from the old Pentaho installation to c: Pentaho libswt win32. I got an hint from this post: In summary, this dll is related to integrated authentication, i.e.

Logging into a SQL server with your Windows ID, rather than explicitly telling the driver your id and password. I do not honestly understand why the old installation had this file and the new one doesn't, but this works. Other alternatives could be getting the same file from Microsof's official jdbc driver (although I'm not sure if that dll would then work only with Microsoft's JDBC or with Pentaho's, too), or from the JTDS package (). Mishkat Al Masabih English.