Azure Auth in Alteryx with VPN connection requiring log in and MFA every 20 seconds

Question

Is anyone out there using a VPN connection to access an Azure SQL database in Alteyrx? We have a database in Azure that has to be accessed via VPN. Authentication is configured to use Azure Active Directory Interactive. I can easily access the database no problem in SQL Server management studio so I know my DNS and VPN settings are working. I can also connect to the database in Alteryx when I first configure an input data tool, but then the trouble starts. Every little change I make to the workflow requires me to reauthenticate my connection with my user name, password and MFA. Sometimes, it will ask me multiple times in a row. And then when I go to run the workflow, half the time it won't even properly connect to the data sources, because i think it can only authenticate one a time and I have multiple input tools??

I would love any advice anyone out there has on dealing with this... It takes me 30 minutes to make the most minor of changes to a workflow.

dataguyW · Answer

I have had a similar experience with SnowFlake.  The login forced me to use an external authenticator and every time my workflow changed it seemed to throw up a login page.    I asked the dba's for a system account that could be used since my workflow would ultimately run from a schedule with no one to authenticate and they obliged.  It may or may not help you, but could be an option to at least check into.