Could you help me to find the reason why the MSSQL connection works in server deployed workflow but not locally in same server machine?
The same workflow works on server but not when I execute those nodes locally using the server executor… any ideas why?
Below the node configuration and the error from the local execution:
ERROR DB Connector 0:743:0:635 Execute failed: Kerberos Login failed: Integrated authentication failed. ClientConnectionId:75527da8-a0b0-4a8e-83a0-f6f637379858 due to javax.security.auth.login.LoginException (Cannot get any of properties: [user, USER] from con properties not available to garner authentication information from the user)
If I understand correctly you run this workflow on the KNIME server and it works. When you run the workflow using KNIME AP on the same machine as the Server it does not.