Connection String to connect Azure as SQL connection

Help Activities
, ,
1

Hi Team,

This is how I am able to connect from SQL [Studio]. Using MFA and my email address. When I click connect, it goes through a set of screens to ask for the password and the MFA stuff. As you can see, I can’t do this from UiPath [Studio]. It has to be a silent login like it would if it was an on-prem SQL server with windows authentication.

Can someone help me with Connection String for this scenairo.

image

2

@MohammedShabbir

It looks something like this

<connectionStrings> 
<add name="DBName" 
   connectionString="data source=localhost;
   initial catalog=<cat>;persist security info=True; 
   Integrated Security=SSPI;" 
   providerName="System.Data.SqlClient" /> 
</connectionStrings>

basically replace username and password with integrated security

cheers

3

I can manually login with Server Name and Username.

There’s no password, access is on my Username.

Can you help me with connection String

4

@MohammedShabbir

The above provided one is for the same…it uses windows auth

cheers