No Columns Returned - ONLY from server

[StolenColon]

Hi all,

I have a workflow with an input using ODBC connection from server to connect to a SQL database and select* a small table.  It works as expected when running from designer locally, and on the VM where Server is installed.

When I attempt to save to the gallery the validation fails stating "No Columns Returned".  Looking at the logs of the validation job I see the connection is made, just no columns returned,

After testing further I see that any input tool configured to look at this specific database yields the same results (fine on designer, no columns returned on server).  Anybody have any suggestions??

Thanks!

[StolenColon · Accepted solution]

Turns out it was permissions for my worker - had to get the "real IT" guys involved....haha