Power Automate - SQL connector for Azure SQL DB

(1) Share

Report

Posted on by Mey_PP

I have Azure SQL DB and trying to create connection "SQL Server" .

Selected the SQL server authentication , entered server , credentials details. But create button is not enabled .

It is asking for the gateway .

For Azure SQL , we do not need the gateway. But not sure why I'm not able to create the connector . I looked into all the videos and forums. Any help will be appreciated.

Categories:

Using connectors

All responses (4)

Answers (0)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Mey_PP Prerequisites for SQL connection:
Gather the following information for a database that contains at least one table with a primary key:
the name of the database
the name of the server on which the database is hosted
a valid user name and password to connect to the database
the type of authentication needed to connect to the database
If you don't have this information, ask the administrator of the database that you want to use.
For an on-premises database, identify a data gateway that was shared with you (or create one).
Reference: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-azure-sqldatabase

Hope you have followed above Prerequisites ?

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB
Mey_PP 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm trying to create SQL server connection from Power Automate --> Connections . I do have all the information required like Server, DB Name , User Name , Password. But it is asking for gateway which is not required for connecting azure SQL .
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Mey_PP , Gateway information is only require when you are using On-Premises instance. Could you confirm which SQL you are using, I mean :
If it is Paas then gateway is not required, however I suspect that you have SQL installed on some VM. The 3rd option (Iaas).

Reference: https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB
Mey_PP 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Im able to connect to SQL without Gateway . But I have to go to the power Platform and connections . If I use power Automate and connection , it requires gateway . Thank you.