Azure MFA database connection

[Danny-Farrar]

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! 

[apathetichell]

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.

[Neffarious23]

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.