I’m trying to find an answer somewhere but with no luck. Our unattended robot services run as individual service accounts, one for each VM. This is all they have permissions for, one service, one VM. Currently to connect to a sql server i’m using SQL authentication but it’s frowned upon and i’m being asked to investigate going to windows authentication.
I don’t want to use the service accounts to connect to SQL as that breaks policy and it would be an overhead to have many service accounts registered to however many SQL server database I need to connect to.
So, can I run the automation against the robot account and impersonate another AD account to run the database connect activity.
thanks
Chris