Just noticed this today. Its not new for me to crate actions to this SQL database via this connector. I get this:
Good question. Before this method, the only resolution I had was to RECREATE the entire flow!! Its like the connection just needs a kick in the butt, then its all good.
5 Hours and nothing worked. Messed with Gateways, Databases, Security, and on and on. Then I read your post. Bingo. Well done. What the....?
Ok, this is what fixed it...
Sorry MS, I get credit for this one...
Ok, MS... did someone do something? It just now started working...