Alteryx Designer - MS SQL Server connection with Azure Active Directory - Univers with MFA

[Mustang9]

Hell Everyone,

I got Alteryx designer for first time. need help connecting Alteryx to MS SQL Server using Azure Active Directory - Universal with MFA.

below are the details that I use in SQL server client with VPN (laptop is not client's laptop)

Server Type: Database Engine

Server Name: XXXX1iednadb01.database.windows.net

Authentication: Azure Active Directory - Universal with MFA

Username: client email with my password that I set up for SQL server

Can I connect Alteryx to MS SQL server with above AAD details or Do I need to get user authentication from the client.

Thanks in advance,

Sridha

[Qiu]

@Mustang9 
we usually use the Windows Authentication.
In your case, maybe the SQL Authentication?

[Mustang9]

Qiu,

Below error after applying SQL Authentication setting below.