There are a number of older posts on integrating a database with Knime, however I haven’t found any discussions regarding the latest versions of Java, Knime, and SQL. I have spent days looking at forums here and on StackOverflow and elsewhere trying to connect to a database with Knime, however nothing has worked.
My computer configuration is as follows:
64 bit Operating System
Microsoft SQL Server 2017 (64 bit version)
Microsoft SQL Server Management Studio 17
Microsoft JDBC Driver 7.0 for SQL Server
KNIME 3.7.0 (64 bit version)
Java jre1.8.0_191
So far I’ve tried:
Downloading java versions into both Program Files\Java and Program Files (x86)\Java. Currently I have the java version that is stored in the Program Files directory.
Downloading and unzipping the ‘sqljdbc_7.0.0.0_enu’ JDBC 7.0 Driver. I also tried the JDBC 6.0 Driver, but that didn’t work.
putting sqljdbc_auth.dll in the C\Program Files\Java\jre1.8.0_191\bin and C\Program Files\Java\jre1.8.0_191\lib directories.
Enabling TCP/IP Port in Microsoft SQL Server Management Stuido
configuring Knime’s Database Connector, Database Reader, and Microsoft SQL Server Connector nodes to the following settings:
Database driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Database URL: jdbc:sqlserver://(localhost); integratedSecurity=true;
Authentication: Checked ‘Use credentials’ (for Database Reader this feature is blocked out)
When I execute the Database Connector node I get the following error:
ERROR Database Connector 0:2 Execute failed: Could not create connection to database: no sqljdbc_auth in java.library.path
When I execute the Database Reader node I get the following error:
ERROR Database Reader 0:1 Execute failed: This driver is not configured for integrated authentication. ClientConnectionId:4906d2f3-e3df-4016-a383-29840cb4dee2
When I execute the Microsoft SQL Server Connector I get the following error:
ERROR Microsoft SQL Server Connector 0:5 Execute failed: Could not create connection to database: no sqljdbc_auth in java.library.path
ERROR Database Connector 0:2 Execute failed: Could not create connection to database: Driver “org.postgresql.Driver” does not accept URL: jdbc:postgresql://localhost;
Could you show me how you have your node configured?
So you are trying to connect to SQL Server that is located on your computer. I’m I right?
Anyways if you can share a bit more info that would help in troubleshooting. What steps have you performed? What KNIME version you got? What database Integration are you using? What URL have you tried? What error are you seeing?
Additionally here is a link to Database Guide you might find useful
Hi,
just had the same problem but then remembered that I’ve solved this earlier
You need to open the knime.ini in the installation directory of knime (c:\program files\knime\…).
Add a line like this
-Djava.library.path=D:\Microsoft JDBC Driver 7.4 for SQL Server\sqljdbc_7.4\deu\auth\x64
Replace the path “D:\Microsoft JDBC Driver 7.4 for SQL Server\sqljdbc_7.4\deu\auth\x64” with the one to the “auth” subfolder of your JDBC Driver for SQL Server, either to the 32bit or 64bit version.
Restart KNIME.
Had a similar problem with MS SQL Server 2017, adding the instance to the connection string helped
jdbc:jtds:sqlserver://localhost:1433/;instance=SQLSERVER2017
