Hey there, I created a local SQLExpress db on my computer so that I didn’t have to write the outputs of my pipeline to excel files and could write them to db tables instead for further analysis using other tools. The SQLExpress db I created is hosted locally - localhost\SQLEXPRESS;Knime_Analytics . It is configured to accept windows as well as SQL Server auth. I have allowed remote connections. A login user “knime” has been created with a password that does not need to be changed after first login nor does it expire. Login is enabled and has been granted dbowner permissions for the specific database that KNIME will write to, i.e. user mapping. In windows firewall, inbound connections via TCP1433 is allowed. SQL “server” was restarted. However I continue to get the error against the username. I’m using Microsoft SQL Server Connector as follows - [image] But when I execute the node, I still get the error. Any insights or help would be appreciated. Thank you :pray: [image] P.S. I can hit the db via SSMS as well as using Get Data in Excel and PowerBI without any issues, which leads me to believe problem lies with KNIME.

Thank you. Based on your suggestion, the following worked - [image]

Look if this is helpful [image] How to connect to SQL Server Express: you must specify the port number and not the instance name. Can this be added to a FAQ and to the documentation? KNIME Analytics Platform I present below some information on how to connect to a Microsoft SQL Server Express database; unlike most other software relying on JDBC, Knime requires you to input the port number, not the instance name. I hadn’t found this mentioned anywhere. It would be good to add this in some kind of FAQ and in the official documentation. I am not sure if the same applies to full versions of SQL Server I took the liberty of creating another thread because I think this title is more representative; if th…

@pborah welcome to the KNIME forum. Have you considered using a local SQL standalone database like SQLite or H2? [image] KNIME, Databases and SQL TL;DR: use the power of SQL databases with low-code data analytics platform KNIME — also on your local machine Reading time: 8 min read

Microsoft SQL Server Connector- Error 5:53 Execute failes: Login failed for user " "

KNIME Analytics Platform

izaychik63 July 3, 2024, 7:30pm 2

Look if this is helpful