Enable Access to work with Azure Multi-Factor Authentication
There seems to be no way of allowing Access to link to an Azure SQL database where Azure Active Directory Multi-Factor Authentication has been enabled. This means that if an IT department switches on MFA Access can't connect to an Azure SQL database it can connect to where MFA has not been activated.
If I have missed something, please tell me!
Alan Cossey
shared this idea
AdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
responded
Thank you for your feedback. There is not a current plan to enable Access to work with Multi-Factor AAD, but this is certainly being discussed with the team. We will provide updates as soon as we decide that this item will be planned for the near future.
2 comments
-
John
commented
I've got an Access app set up with an Azure SQL backend and MFA with AAD. This connection string works fine:
Driver={ODBC Driver 17 for SQL Server};Server=tcp:SERVERNAME.database.windows.net,1433;Database=DATABASENAME;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;Authentication=ActiveDirectoryInteractive;UID=;The key part is to ensure that authentication is ActiveDirectoryInteractive.
-
Alan Cossey
commented
So, if an IT department switches on MFA, how do I continue to use Access to connect to the Azure SQL database, please? Have I missed something obvious?