I'm connected to my database, but after setting up a script and running it, I'm receiving the error in the logs below:
Failed to connect.
The connection properties were not set up properly.
Ensure the correct connection from the drop-down list is selected from the connection properties in the Automation script.
If you are using two different windows users to create/modify the script and another one to schedule/run the automation with, make sure they both have the correct connection saved with password.