Connect to Azure SQL server

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:
2019-08-17%2018_58_20-Window

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

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.


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

3 Likes

Hi @celfa,

Can you take a look. It will help you.

Regards
Balamurugan.S

3 Likes

Hi @Lahiru.Fernando

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

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?

2 Likes

Hi @celfa,

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

Regards
Balamurugan.S

2 Likes

Hi @balupad14,

Thanks for your input :+1:
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. :thinking:

1 Like

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

So everything works as it should now :hugs:

Thanks for your input!

2 Likes

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.