April 13, 2022, 11:36am
Hi KNIME Team,
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)
April 18, 2022, 3:16pm
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.
Have you configured the Kerberos authentication on the KNIME Analytics Platform?
April 19, 2022, 9:45am
Yes, I did that and I’m logged in:
April 19, 2022, 1:16pm
It looks like you are using Microsoft Integrated Authentication. Have you seen this thread?
connect to ms sql server by windows authentication - #2 by tobias.koetter
April 22, 2022, 2:54pm
I think it is internal issue with my account as now I see I cannot access normally even with MSSMS.
Will try to clarify and update the post then.
July 21, 2022, 2:54pm
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.