Unanswered

Connecting to Azure SQL Server through On Prem Gateway using AD Authentication

(0) Share

Report

Posted on by andreanidouglas

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,

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
andreanidouglas 14 on at

Like (0)

Report

It is a prem-gateway, but to an Azure SQL, which does not have Windows authentication

Was this reply helpful? Yes No
andreanidouglas 14 on at

Like (0)

Report

It is a prem-gateway, but to an Azure SQL, which does not have Windows authentication

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
andreanidouglas 14 on at

Like (0)

Report

Azure SQL

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

To the best of my knowledge there is no way to use an on-premises gateway to connect to an Azure SQL database in the cloud using AAD.

Was this reply helpful? Yes No