Question: if I am using KNIME desktop on a virtual machine living on a specific server and network, can I connect to a MS SQL Server db on a different network behind a firewall?
Ex: KNIME dev on 192.168.X.X <–> [Firewall] <–> MS SQL Server 2019 on 10.5.X.X.
it is rather a networking/vm related question. In general, this should be possible if the VM is configured to be also a part of the DB’s network and the firewall is configured to grant access.