Notifications
Announcements
Hello,
Is it possible to use Interactive authentication for Azure SQL on Power Automate? I got it working in python with an ODBC but I don't see that as an option. I tried with Integrated security but I can't specify the server there?
PA Cloud or PA Desktop?
PA Cloud
For the overwhelming majority of scenarios you need to assume that PA Cloud has no user interface and therefore cannot be interactive. There are some punchouts like approval workflows and Teams adaptive cards, but I can't see them being useful in your scenario.
Integrated Security/SSPI assumes the presence of a NT user account - which is not a thing in PA Cloud.
So how are we supposed to connect with an azure sql database with PA Cloud if username/password (basic authentication) is not an option?
AAD - Azure Active Directory authentication in the SQL Server connector | Power Automate Blog (microsoft.com)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 501 Super User 2025 Season 2
Tomac 323 Moderator
abm abm 237 Most Valuable Professional
