You’re offline. This is a read only version of the page.
14
I've been trying to setup a connection to an Azure SQL Server,
due to company policies, we are not allowed to open the firewall directly, so, we are going to use a On Prem data gateway to route traffic through. We already have the gateway, and we use it for PowerBI normally.
When setting up the connection in Power Automate, I don't get the option to select the gateway through AD connection, only if I select Windows Auth or SQL Server Auth.
How should I complete this connection?
Thank you,
Azure SQL
Azure SQL database or Azure VM running SQL? I'm not sure you can connect to an Azure SQL database through an on-premises gateway. I know you can connect to an Azure VM running SQL. But that would act like an On-Premises server and use a local AD or Azure AD services so it would be windows Auth.
It is a prem-gateway, but to an Azure SQL, which does not have Windows authentication
It is a prem-gateway, but to an Azure SQL, which does not have Windows authentication
If you are going through an on-premises gateway then the server you are connecting to is on-premises as well. AAD authentication would be for Azure AD, which is only available in the cloud. What you want is Windows Auth which will use the on-premises AD credentials. That's why you don't see the gateway for Azure AD authentication.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
