How to connect to SQL server using Azure Active Directory - Universal with MFA?

Like (0) Share

Report

Posted on 28 Jul 2023 13:43:30 by hongkong

271

We have a Azure SQL server database I need to connect to it using Azure Active Directory - Universal with MFA. I can connect the DB with SSMS. Also my Power Apps is able to connect. However I cannot setup Power Automate SQL action "when an item is created (V2)". I picked authentication type = Azure AD integrated. I type in the SQL server name and DB manually (because it is not shown in the dropdownlist) and not able to list the tables. What should I do?

All responses (1)

Answers (1)

Verified answer

lbendlin 8,081 Super User 2025 Season 2 on 30 Jul 2023 at 12:07:53

Like (0)

Report

Re: How to connect to SQL server using Azure Active Directory - Universal with MFA?

MFA requires a "manual" portion of the process to be present. Unless you can emulate that (various hints on the interwebs) you must find a different authentication process.