We are trying to make an SQL connection to a database with a Windows Authenticated (service account).
Our policy prevents us from using SQL accounts so our options are limited to using a service account. The development tool (database Activities) has that as an option but uses the developer currently logged in. Is there a way to create a connection profile that the integration can use? Either natively or with a C# module?
It is the only secure way to do it, to use the logged in user, but if you are wiling to develop something, then you could provide some other credentials to use instead, your custom activity would have to output a connection as the type UiPath.Database.DatabaseConnection to be able to be used with built in execute database commands activities.
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123