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.