Trouble connecting to 2012 SQL Server Database


I am having trouble connecting to a 2012 SQL Server Database using KNIME v.3.4.1. and the SQL Server Connector

In the connecting settings, I have added the SQL Server Instance (ServerName\Instance) under the Hostname, used the default port, added the database name, and entered the user name and password.

However, when executing the node, I get the following error " WARN Microsoft SQL Server Connector 0:4 No credentials or username for authentication given".

We also have SQL Server databases for which the access is controlled by our system/network credentials. I have tried a couple of those and I am getting the same error.

I can access these databases from SQL Server Management Studio with no problems.

Any assistance would be greatly appreciated.



good morning

maybe this link will give you more guidance: