Feedback by UserVoice

I suggest you ...

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!

3 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Alan Cossey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • John commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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?

Feedback and Knowledge Base