We are still preparing the deployment of Toad Data Point and Toad Intelligence Central.
Users will connect to TIC and to our MS SQL Server using their own windows login (Active Directory).
In order to prevent their automated scripts to fail in case they changed their windows password, we will be using the "automation scripts managment page under Objects" to make sure all the automated scripts run with the windows service user name (which has access to the database).
But is there a way to perform this action automatically using the API or other method? We don't want to login manually with the root user everyday to update new automated scripts.
We are new to Toad, so any help or any other suggestion would be appreciated.