execute workflow with database in knime server

KNIME Server
,
1

Hi im new working whit Knime small server, i’ll be trying execute workflow, this contain someones querys (database SQLServer), but always is the same error

image
image1328×464 44.3 KB

How execute DB_Query_Reader in Knime Server ?
This is a pat of flow
image

2

Hi,
Do all SQL Server Connectors in your workflow reach out to the same server? Maybe it makes sense to reuse a single server connector for all DB Query Readers? Otherwise the server might reject a login because too many login requests come from the same IP, I guess. I assume the same workflow works locally? It could also be a network issue where no connection can be established.
Kind regards,
Alexander

1 Like
3

Thanks @AlexanderFillbrunn, i have the same Host but different DB, i run newly the process and work it but now i have to upgrade the server

image
image1057×21 1.97 KB

4

Hi,
You can either redo the workflow in an older AP, or you can also set the reject_future_workflows setting to false like it is explained here.
Kind regards,
Alexander

5

Thanks @AlexanderFillbrunn i review it