I am trying to connect to our SQL database in Azure. The SQL database uses azure active directory with MFA for authentication. How can I use that in N8N or do I need to use the admin account and password?
How would you connect if you were using another sql client? I am not sure how the 2FA part would work but I guess there could be app passwords for it that you can use.
In SQL server management studio there is an option for the azure active directory login with MFA. I was able to find a workaround, but am still curious how others solve for it.