Microsoft SQL Server Connector - no password

We have a new SQL database available at work which will be extremely useful. However, the connection actually doesn’t have a password, but Knime will not accept blank as a valid password!

Can anyone suggest a way around this?

I finally managed to figure it out. I had to create the variables in table creator, change the missing password to blank with rule engine (MISSING $Password$ => “”) create variables, use the Variables to Credentials node and then use “credentials” rather than username/password in the SQL connector node.

Hopefully this explanation will help someone in future!


Glad you found a way through. Thanks for posting your solution!

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