Azure MFA database connection

Question

Hi,

I'm trying to connect to an Azure database that requires MFA on desktop designer. I've been able to establish a connection but making almost any moves causes a re-authentication notification - which I then have to enter my password and then put in the authentication code. If I am to connect to the database, select a table and run some data out, I am having to re-authenticate 3 or 4 times which is not feasible.

I've noted a few discussions in the past where others have had similar experiences but has anybody found a workaround and/or do we know if Alteryx are working on fixing this?

Thanks!

Wesley Mendonca · Answer

Is someone get sucessed on this ? @Danny-Farrar @Neffarious23

Neffarious23 · Answer

We have a similar MFA requirement for individual accounts connecting to Azure SQL data.  Building System DSN ODBC connections seems to avoid the re-auths.  Another alternative is to use a Service Account with a SQL login to the target database which does not require MFA but requires access to the password via an identify vault.  This approach may be limited by your SecOps rules however.

apathetichell · Answer

I'm not an Azure person - but these kind of issues are usually upstream at the database or with the ODBC driver. I'd check what the token timeout is with the underlying database.