Connect to Azure SQL server

[celfa (Claus)]

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 the package in my package manager, so I added it manually from this link

Are there any newer versions?

I’ve tried to establish a connection to my SQL server but it refuses all the time. I’m able to connect with Microsoft SQL Server Manager Studio. I’ve tried the wizard which the activity provides and also to create the connection string by my self without any luck.

In Azure I can see there are 4 types of connections:

Have anyone tried to make a connection to a SQL server in Azure?

[Lahiru.Fernando]

HI @celfa

I haven’t used Azure connection through UiPath. However, I do work with Azure databases from other applications. We mostly use ADO.NET connection option to connect with Azure databases as that seems to be the only working connectivity driver for us.

The component you mentioned is the latest version. So it should be fine. Try with the ADO.Net connection manager. If the driver is not installed, you might need to get it installed as well…

Refer to below links for the connection strings as these might help.

How to add Azure SQL Server connection string to app.config in Windows Forms?

https://www.connectionstrings.com/sql-azure/

[balupad14 (Balamurugan)]

Hi @celfa,

Can you take a look. It will help you.

UiPath Go ! Azure Table Storage

Hi All, Here is an activity reads the data from Azure table storage and it converts it to DataTable. It offers features like column and row filters. It is from my Official Connect. Regards Balamurugan.S

Regards
Balamurugan.S

[celfa (Claus)]

Hi @Lahiru.Fernando

Thanks for your input! I’ve still not managed to connect successfully. I’ve tried almost everything now .

Thank you @balupad14
Your link only relates to reading data from an Azure table, I need to update a row. Do you know how to do it, or how a connection string should be written?

[balupad14 (Balamurugan)]

Hi @celfa,

you can get the information about the connection string from resource tab → InstallationGuide.docx

Regards
Balamurugan.S

[celfa (Claus)]

Hi @balupad14,

Thanks for your input
I cannot use this kind of connection string to connect to my SQL database. And your activity only supports read, so I can’t see how I can use this?

Any other thoughts? I can’t be the only one who needs to update a row in an Azure SQL database.

[celfa (Claus)]

And now I finally figured out my issue was related to firewall rules

So everything works as it should now

Thanks for your input!

[Lahiru.Fernando]

Thank you for sharing the solution… and glad to hear its working