Connect to Azure SQL server

Help
1

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:

2

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
3

Hi @celfa,

Can you take a look. It will help you.

Regards
Balamurugan.S

3 Likes
5

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
6

Hi @celfa,

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

image
image933×257 13 KB

Regards
Balamurugan.S

2 Likes
7

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
8

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!

3 Likes
9

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

1 Like
10

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