Connecting to Azure SQL Server database

Help Activities
, ,
1

I have an azure SQL Server created on our corporate account tied to our Azure AD. Has anyone tried connecting to such a database from UiPath? The conventional UiPath.Database.Activities does not lend itself to Azure Active Directory enabled SQL Server. It only allows connecting to the normal on-prem sql server, that only allows Windows or SQL Authentication, not Azure AD.

Please help with samples.

2

Hey @savantsa

Can you try to get the connection string for the same from your Azure console ?

Thanks
#nK

3

Also, have a look at - Activities - Get Table

4

I’ve already seen these links. Two of them are for azure tables, not the same as sql server database tables.

The other for sql server doesn’t actually contain any solution to connect to the azure sql server database.

It’s only after seeing all these links, I created this new post.

5

Okay @savantsa

Can you connect the same from SQL server studio ?

6

No. That’s exactly where I want to connect from and I’m unable to. I’m able to connect from sql management studio.

7

Hey @savantsa

Could you please show a snap on the connection string in SQL server studio ?

Thanks
#nK

8

image

1 Like
9

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.

1 Like
10

I can understand @savantsa

But Once you get successfully connected please check connection string property and show here please…

11

image

How do I get the connection string? I thought if you right-clicked on the connection, the properties would show that. But I don’t see an option to view the properties.

1 Like