UiPath Database Connection with Microsft Entra MFA from UiPath

Help Studio
, ,
1

Hi, is there any way to connect to a SQL database that uses Microsoft Entra MFA directly from UiPath? i’ve tried using Authentication=ActiveDirectoryPassword in the connection string but fails to connect, likely because the account requires MFA.

Here’s the error: Connect to Database: Failed to authenticate the user in Active Directory (Authentication=ActiveDirectoryPassword). Error code 0xunknown type

2

Hello @wytwy96

I would assume that you need to create a dedicated service account for your automation/service/application.
These types of accounts would bypass the MFA required for users.

In relation to Microsoft Entra it seems to be refered as Managed identities.

Regards
Soren