How to connect SQL Server which is in remote machine?

[Tamilarasanaccet (Tamil)]

Hi All,

I am trying to connect the SQL SERVER which is in remote machine using the UiPath connect activity? and below is the connection string I am using, through VPN i have to connect this machine.

Server=myip;Uid=mymachineloginid;Pwd=loginpassword;Database=dbname;

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @Tamilarasanaccet,

Have you tried to use configuration wizard under connect activity to automatically define a connection string?

Or manually used connection string directly?

Using wizard really helps select different options to properly define connection string.

Regards
Sonali