Azure SQL connection - Azure Active Directory

Describe the problem/error/question

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?

Hey @jmullins,

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.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.