Hello,
We changed our SQL Server for our UAT environment.
Now we have a new server (let's say UAT-NEW).
We also have an on premises gateway installed on UAT-NEW.
So, I created a new connection using the new credentials leaving the old one as is.
And now I have two connections (eg. UAT and UAT-NEW).
We also have power automate flows that are based on the old connection which I want to change.
But when I tried to update the existed step, I get only the old server name.
The same happens even when I try to create a new flow - only the old server appears.
On the other hand, when I enter into another environment where there were no connections at all, the new connection was available.
That made me think that it's probably not possible to use two on-premises gateways connections in the same environment.
Is it so?
I didn't manage to find any documentation for that - please provide.
If not, how can I use the second connection in the same or new flow?
Thank you,
Nikos
