# Database MSSQL Connection error

**URL:** <https://forum.knime.com/t/database-mssql-connection-error/23561>\
**Category:** KNIME Analytics Platform\
**Created:** [May 12, 2020, 2:51pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561 "2020-05-12T14:51:36Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![shubhamss](https://forum-cdn.knime.com/user_avatar/forum.knime.com/shubhamss/32/15186_2.png) [@shubhamss](https://forum.knime.com/u/shubhamss)\
**Post date:** [May 12, 2020, 2:51pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561/1 "2020-05-12T14:51:36Z")

</div>

I am trying to connect to a MSSQL database with server name as:  
**[prod-companyx-workplace-resources.database.windows.net](http://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!

---

<div class="post-metadata">

**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\
**Post date:** [May 12, 2020, 4:03pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561/2 "2020-05-12T16:03:40Z")

</div>

Hi there @shubhamss,

what driver are you using? Make sure you follow instruction from database guide how to register driver properly 😉  
[https://docs.knime.com/latest/db\_extension\_guide/index.html#intro](https://docs.knime.com/latest/db_extension_guide/index.html#intro)

Br,  
Ivan

---

<div class="post-metadata">

**Author:** ![shubhamss](https://forum-cdn.knime.com/user_avatar/forum.knime.com/shubhamss/32/15186_2.png) [@shubhamss](https://forum.knime.com/u/shubhamss)\
**Post date:** [May 12, 2020, 5:39pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561/3 "2020-05-12T17:39:53Z")

</div>

> **[SSMS: Connect and query data - Azure SQL Database](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms)**
>
> Learn how to connect to SQL Database on Azure by using SQL Server Management Studio (SSMS). Then run Transact-SQL (T-SQL) statements to query and edit data.

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

---

<div class="post-metadata">

**Author:** ![shubhamss](https://forum-cdn.knime.com/user_avatar/forum.knime.com/shubhamss/32/15186_2.png) [@shubhamss](https://forum.knime.com/u/shubhamss)\
**Post date:** [May 12, 2020, 8:35pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561/4 "2020-05-12T20:35:09Z")

</div>

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

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/c/fce30e7f8db6198f3e37e9146e06c6e11246e5a2.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/2/32e81aac78cc759cf1c5be32436d8d4eab2e75cf.png)  
In the description is the Database URL. I made a Python version  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/5/954a3daa34d34928be392dc29dec76879a8c3f54.png)  
which works like a charm.

---

<div class="post-metadata">

**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\
**Post date:** [May 13, 2020, 5:10pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561/5 "2020-05-13T17:10:19Z")

</div>

Hi there @shubhamss,

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

> [@Connect to Azure Database](https://forum.knime.com/t/connect-to-azure-database/20585):
>
> Hello, I am using Knime and I would like to connect to the Azure Database. I tried the Microsoft SQL Server Connector node and encountered an error. ERROR Microsoft SQL Server Connector 0:1 Execute failed: Failed to load ADAL4J Java library for performing ActiveDirectoryPassword authentication. I have downloaded the [ADAL4J](https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver15) from Microsoft including the dependencies and also the JDBC driver from Knime installation marketplace. I have tried the following: Create a plugin and include t…

Br,  
Ivan

---

<div class="post-metadata">

**Author:** ![marten\_kose](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/a87d85/32.png) [@marten\_kose](https://forum.knime.com/u/marten_kose)\
**Post date:** [May 14, 2020, 1:03pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561/6 "2020-05-14T13:03:58Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [May 21, 2020, 1:04pm UTC](https://forum.knime.com/t/database-mssql-connection-error/23561/7 "2020-05-21T13:04:03Z")

</div>

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