SQL Connection through Microsoft Power Automate without Gateway

(0) Share

Report

Posted on by Community Power Pla...

Hello,

We are actually connecting to SQL from Power Automate. But it is asking us to select gateway.

When it is Azure SQL it shouldn't ideally ask for Gateway rite. But it is asking.

Please help us how to set Azure SQL connection without using the Gateway.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous you are correct (assuming the authentication type is Azure AD or SQL Authentication, Windows Authentication expects a gateway) A. can you share a screenshot?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello,

My issue is when we connect to Azure sql there is no need to enter gateway. Gateway is only for On Prem connection.
But for me when connecting to Azure it is still asking the gateway.

Please see my screenshot below.
If i connect without gateway i will get below error if i enter gateway and connect it would connect.
But i dont want to use gateway as it is not required for Azure sql.
Please help me in solving this issue.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

When you connect to Azure sql, you don't need to choose a gateway .
If your interface is like this, there is no need to select a gateway, just click 'Create'.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

My SQL is Azure SQL but I am having SQL Authentication to connect through the Power Automate there when I connect it without the Gateway it is not connecting. Only if i enter gateway it is connecting.
But for Azure SQL it shouldn't ask the gateway. How can we connect to SQL without using the gateway through flow.

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @Anonymous when you create the connection choose connect directly

When you select on-prem it asks for gateway.

Is your connector requestion a gateway whn you choose connect directly?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

That Option is not there for us to select the type:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

How can we have a call with Microsoft support for the issue to be resolved?

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @Anonymous your admin can log a ticket for you at Power Platform admin center (microsoft.com).

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

Sorry i am confused about your question.
If you choose SQL Server authentication, this is a local connection.
If you want to connect to azure sql, maybe you should use ‘Azure AD integrated’ authenticator.

If you have any ideas, you could submit them to Here .

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
RandaMuhieddine 2 on at

Like (0)

Report

Hi @Anonymous ,
we are having the same issue, were you able to resolve?
if yes, please share the solution.

Was this reply helpful? Yes No