we have a workflow in gallery which uses gallery connection to connect to postgre sql.
from gallery link (in altx server machine or any other rdp machines) : I can run the job successfully.
from gallery link (in my machine) : job failed. Error SQLDriverConnect: FATAL: Client from Azure Virtual Networks is not allowed to access the server using Private IP. Please make sure your Virtual Network is correctly configured.
As all the jobs in gallery runs with local/service user and connection is defined gallery as well - not sure why the job failing when i run from local machine and success in server.
just FYI - from local machine i can not connect to postgre due to firewall. does who triggers the job and from where is matters to gallery connection?