# KNIME SQL Server connection no longer working

**URL:** <https://forum.knime.com/t/knime-sql-server-connection-no-longer-working/46104>\
**Category:** KNIME Analytics Platform\
**Created:** [August 18, 2022, 11:45am UTC](https://forum.knime.com/t/knime-sql-server-connection-no-longer-working/46104 "2022-08-18T11:45:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JWebb](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/97f17d/32.png) [@JWebb](https://forum.knime.com/u/JWebb)\
**Post date:** [August 18, 2022, 11:45am UTC](https://forum.knime.com/t/knime-sql-server-connection-no-longer-working/46104/1 "2022-08-18T11:45:47Z")

</div>

Hello,

I updated to v4.6 this morning and now none of my SQL server connections work. “Execute” is greyed out and I have an error message I do not understand:

WARN Microsoft SQL Server Connector 5:114:49 To register the driver go to File-\>Preferences. In the preferences go to KNIME-\>Databases and register a new driver for the database type mssqlserver by clicking on the Add button.  
WARN Microsoft SQL Server Connector 5:114:49 Please register a compatible driver via the KNIME preference page. (For details see the log file)

I am not sure what this means and the instructions are not clear to me. I cannot figure out what to do after clicking the Add button as instructed. Can anyone in the know help? Most of my workflows connect to source data using this! Thank you.

---

<div class="post-metadata">

**Author:** ![ArjenEX](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/97f17d/32.png) [@ArjenEX](https://forum.knime.com/u/ArjenEX)\
**Post date:** [August 18, 2022, 11:53am UTC](https://forum.knime.com/t/knime-sql-server-connection-no-longer-working/46104/2 "2022-08-18T11:53:39Z")

</div>

Hi @JWebb

Closing and re-opening your KNIME should resolve it. This is a known thing with the V4.6 update.

> [@DBDriver Registry Error after updating to KNIME 4.6](https://forum.knime.com/t/dbdriver-registry-error-after-updating-to-knime-4-6/44431):
>
> I just updated to KNIME 4.6, and now I can’t connect to my Microsoft SQL Server Database. Here’s a list of some of the errors and warnings that populate when I try to run my workflow. Any suggestions on how to fix this? ERROR DBDriverRegistry Database driver wrapper creation failed for driver (H2) "H2". ERROR DBDriverRegistry Failed to load built-in database driver (H2) "H2" from extension org.knime.database.extensions. ERROR DBDriverRegistry Databas…

> [@MYSQL Drivers Un-Installed](https://forum.knime.com/t/mysql-drivers-un-installed/44194):
>
> Hello, When I installed the new version of KNIME (4.6.0), all the previous installed MYSQL drivers were un-installed. As a result, 90% of my KNIME workflows cannot be run, because I cannot connect to MYSQL. Please help, Alex

> [@Database Driver isnt´t load after installing the new KNIME Version 4,6](https://forum.knime.com/t/database-driver-isnt-t-load-after-installing-the-new-knime-version-4-6/44467):
>
> Hi, i have a problem after installing the new Version of KNIME 4.6. I can´t choose the special Database Driver in the DB Connector node. Thank you in advance for your help Greetings

---

<div class="post-metadata">

**Author:** ![JWebb](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/97f17d/32.png) [@JWebb](https://forum.knime.com/u/JWebb)\
**Post date:** [August 18, 2022, 11:59am UTC](https://forum.knime.com/t/knime-sql-server-connection-no-longer-working/46104/3 "2022-08-18T11:59:42Z")

</div>

How strange! I restarted at least twice (including once to try and get the drivers back) and nothing happened…but closing and re-opening has worked!

Panic over 🙂 Thanks!

---

<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:** [August 25, 2022, 11:59am UTC](https://forum.knime.com/t/knime-sql-server-connection-no-longer-working/46104/4 "2022-08-25T11:59:42Z")

</div>

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