Hello Friends,
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”.
Data Source=myserver.database.windows.net;Initial Catalog=myDataBase;User Id=mylogin@myserver;Password=myPassword
OR
Server=tcp:myserver.database.windows.net,1433;Database=myDataBase;User ID=mylogin@myserver;Password=myPassword
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.
Thank you,
Navneet
Happy Automation