Azure SQL using App Password
I am trying to add an Azure SQL Datasource using my Azure Active Directory account. I have MFA enabled so I've generated an App Password using the process described at https://docs.microsoft.com/en-us/azure/multi-factor-authentication/end-user/multi-factor-authentication-end-user-app-passwords#manage-app-passwords-in-the-Azure-portal.
When I click Test Database I get the following error:
Unable to connect to the database!
Failed to authenticate the user blah@blah.com in Active Directory (Authentication=ActiveDirectoryPassword).
Error code 0xCAA90002; state 10
WSTrust response does not have recognized SAML assertion.
All Comments (1)
Azure AD with MFA to connect to Azure SQL is not yet officially support by the Microsoft .NET Framework. It was announced a few weeks ago that with the .NET Framework 4.7.2 Developer Pack Early Access build 3056 MFA will be possible.
The issue then becomes how/when do we move to 4.7.2 without adversely affecting every client (forcing them to install 4.7.2). We will figure something out I'm sure.
You can follow this thread: https://forum.devolutions.net/topic24374-azure-sql-database-using-azure-ad-identities.aspx#post113872
Stéfane Lavergne