# Error when using database connector

**URL:** <https://forum.knime.com/t/error-when-using-database-connector/19104>\
**Category:** KNIME Analytics Platform\
**Tags:** database\
**Created:** [October 28, 2019, 1:10pm UTC](https://forum.knime.com/t/error-when-using-database-connector/19104 "2019-10-28T13:10:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gnime](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/g/9fc348/32.png) [@gnime](https://forum.knime.com/u/gnime)\
**Post date:** [October 28, 2019, 1:10pm UTC](https://forum.knime.com/t/error-when-using-database-connector/19104/1 "2019-10-28T13:10:54Z")

</div>

I am trying to use the dataabse connector but getting the error:

ERROR Database Connector (legacy) 0:28 Execute failed: Could not create connection to database: no sqljdbc\_auth in java.library.path

I registered the JDBC driver in the database(legacy) menu under preferences and copied the sqljdbc\_auth to the KNIME folder on my system.

What else can I do?

---

<div class="post-metadata">

**Author:** ![tobias.koetter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tobias.koetter/32/56844_2.png) [@tobias.koetter](https://forum.knime.com/u/tobias.koetter)\
**Post date:** [October 28, 2019, 1:25pm UTC](https://forum.knime.com/t/error-when-using-database-connector/19104/2 "2019-10-28T13:25:04Z")

</div>

Hello gnime,  
sounds like you are using native authentication (NTLM) for Microsoft SQL Server. For this you need to add the sqljdbc\_auth to KNIMEs class path. Please have a look at this [post](https://forum.knime.com/t/server-configuration-for-ms-sql-active-directory-authentication/18347/6?u=tobias.koetter) on how to do it.  
Bye  
Tobias

---

<div class="post-metadata">

**Author:** ![gnime](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/g/9fc348/32.png) [@gnime](https://forum.knime.com/u/gnime)\
**Post date:** [October 28, 2019, 1:46pm UTC](https://forum.knime.com/t/error-when-using-database-connector/19104/3 "2019-10-28T13:46:14Z")

</div>

Worked!

Thanks @tobias.koetter!

---

<div class="post-metadata">

**Author:** ![izaychik63](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e9a140/32.png) [@izaychik63](https://forum.knime.com/u/izaychik63)\
**Post date:** [October 28, 2019, 2:07pm UTC](https://forum.knime.com/t/error-when-using-database-connector/19104/4 "2019-10-28T14:07:48Z")

</div>

Do we still need to do this manually? Could driver installation place it automatically to the folder?

---

<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:** [November 4, 2019, 2:07pm UTC](https://forum.knime.com/t/error-when-using-database-connector/19104/5 "2019-11-04T14:07:50Z")

</div>

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