execute workflow with database in knime server

[MartelKhan]

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

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

[AlexanderFillbrunn]

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

[MartelKhan]

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

[AlexanderFillbrunn]

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

[MartelKhan]

Thanks @AlexanderFillbrunn i review it