Hello All, I have an automation that connects to a SQL server database, runs query and returns the output as expected in attended mode (on my laptop). However, when I run the automation in an unattended mode on a virtual machine with a service account, the activity that runs the query fails with the below error.
‘Login failed for user XYZ’
I ensured the service account has access to the database, was able to verify in SQL Server Management Studio (SSMS). But, I am not sure why when it runs in unattended mode I get the above error. Can someone please help? Are there any prerequisites (like drivers, SSMS, etc that need to be installed on the virtual machine where this automation is running in unattended mode). I am using Windows authentication to connect to the database (below screenshot)