UiPath Database Connection authentication with AZURE Active Directory

[Renaldo_Qeraxhi1 (Renaldo Qeraxhi)]

I’m trying to connect with database SQL server. But the authentication that I want to use is Azure Active Directory - Universal with MFA is it possible to do it? Because with what I usually worked with is only windows authentication and SQL server authentication.

[Anil_G (Anil Gorthi)]

@Renaldo_Qeraxhi1

Welcome to the community

Please check this

SQL connection with Azure Active Directory

I know this is an old post… but maybe someone is looking for an answer. You just have to make sure you have de ADALSQL.MSI pacakge installed from Microsoft website, after which you can go to the SQL Wizard and make sure you choose what you need from there: [image]

Cheers

[Renaldo_Qeraxhi1 (Renaldo Qeraxhi)]

Yeah I even tried in myself in advance but I don’t have any place to put the password in

Another thing that I tried was to put the connection string myself , but still I get an exception:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect). I have checked multiple time and the name and password are assigned correctly.

“Data Source=server_name;Initial Catalog=db_name;Persist Security Info=True;User ID=”+UserCode+“;Password=”+passcode+“;Encrypt=True;Authentication=ActiveDirectoryPassword”

[Renaldo_Qeraxhi1 (Renaldo Qeraxhi)]

I just found the solution, I played with the options and here it is the connection string:

“Data Source=server_name;Initial Catalog=Database_Name;TrustServerCertificate=True;Encrypt=False;Authentication=ActiveDirectoryPassword;User ID=Username;Password=password”