The machine hosts the gateway needs to be access the ODBC DSN. In your scenario, you need to sign in to get gateway work again in the same machine as ODBC DSN created on.
When you use the on-premise data gateway, please use the same connection information as you defined in desktop. By the way, please always keep the gateway to be run as the latest version.
Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.