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…

Hey @savantsa Can you try to get the connection string for the same from your Azure console ? Thanks #nK

Also, have a look at - Activities - Get Table [image] Connect to Azure SQL server Help Hi guys, I’m trying to connect to a SQL server which is hosted in Azure. I’m using the UiPath.Database.Activities to connect to the server and later do a query. I was not able to find …

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.

Okay @savantsa Can you connect the same from SQL server studio ?

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

Hey @savantsa Could you please show a snap on the connection string in SQL server studio ? Thanks #nK

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 s…

I can understand @savantsa But Once you get successfully connected please check connection string property and show here please…

[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.

Connecting to Azure SQL Server database

Help Activities

Nithinkrishna (Nithin Krishna) June 14, 2022, 2:09am 3

Also, have a look at - Activities - Get Table

Topic		Replies	Views
SOLVED! How to connect Azure SQL Server? Activities activities , question , azure	3	4514	December 3, 2021
Connect to Azure SQL server Help	7	5538	August 20, 2019
Connect to azure to read a db StudioX studiox , question	1	181	May 16, 2024
Connection String to connect Azure as SQL connection Activities activities , question , azure_active_directory	3	842	June 2, 2023
UiPath Database Connection authentication with AZURE Active Directory Activities database , uiautomation , activities , question	3	1750	May 25, 2023

Connecting to Azure SQL Server database

Related topics