Database MSSQL Connection error

I am trying to connect to a MSSQL database with server name as:
prod-companyx-workplace-resources.database.windows.net
with a specific login creds and a database name.

If I use a Microsoft SQL Server Connector node it gives me :

ERROR Microsoft SQL Server Connector 0:16 Execute failed: Client driver version is not supported.

How would I go about solving it!

Hi there @shubhamss,

what driver are you using? Make sure you follow instruction from database guide how to register driver properly :wink:
https://docs.knime.com/latest/db_extension_guide/index.html#intro

Br,
Ivan

The thing is, it is not local database. The guidelines showcase how to local db mssql db.

ERROR DB Connector 0:17 Execute failed: Selected JDBC driver does not support given JDBC url.



In the description is the Database URL. I made a Python version

which works like a charm.

Hi there @shubhamss,

glad to see you found a workaround! To connect to Azure SQL Database from KNIME check this topic:

Br,
Ivan

Hi @shubhamss,

can you provide little more information on how you configured the nodes (Microsoft Sql Connector and DB Connector)? From preference page everything looks fine so far.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.