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