I am brandspanking new at Knime and cannot connect to a MS SQL database.
I drop the Database Connector, configure it to use the Microsoft JDBC driver, but cannot seem to get the database URL field properly configured.
The database I am attempting to connect to is Morty, with username Sam, password 1234.
My last attempt in the database URL field was:
…with Username and Password fields populated.
Each attempt I make results in some variation of:
WARN Database Connector java.sql.SQLException: org.knime.core.node.InvalidSettingsException: Driver “com.microsoft.sqlserver.jdbc.SQLServerDriver” does not accept URL: jdbc:odbc:
Thanks in advance.