I’m trying to connect to a SQL server which is hosted in Azure. I am trying to connect azure SQL server using Connect activity from UiPath.Database.Activities using connection string but unable to connect it, getting “one or more error occurred issue”.
It would be very helpful if you can please let me know if any driver or library needs to be install prior to connect it along with sample connection string.
I installed SQL Management Studio Server 2018.2 driver on server and able to connect azure SQL database using Connect activity from UiPath.Database.Activities package with below connection string
Data Source=myserver.database.windows.net; Authentication=Active Directory Password; Initial Catalog=myDataBase; User Id=mylogin@myserver; Password=myPassword
Hope this solution works for others too who is trying to access Azure SQL Server.