'Access Denied' error when executing Toad DevOps Toolkit (TDT) v1.2 as a (non admin) service user (using Bamboo agent)
说明
When running Toad DevOps Toolkit (TDT) in a CI/CD pipeline orchestrated via Bamboo, TDT is installed on a remote Bamboo Windows agent. The execution fails with a permission failure.
Steps to reproduce: * Installed TDT 1.2 as an admin user. * Successfully tested execution of a database compare as admin user * Successfully tested execution of a database compare as logged-on user DOMAIN\Test with no admin rights, and is the same user running the Bamboo agent.
* Although above is successful, execution though the Bamboo agent run as DOMAIN\Test is unsuccessful with the following error message: build 04-Jan-2019 16:17:01 Starting TDT... build 04-Jan-2019 16:17:01 ERROR detected: Retrieving the COM class factory for component with CLSID {4DDCFF78-BFD6-4C5F-AED9-C3D07E0E92D5} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
* Trying to adjust the permissions in Component Services > ... > ToadAutoObject Object > Security leads to a different error: build 04-Jan-2019 16:48:20 Starting TDT... build 04-Jan-2019 16:48:39 ERROR detected: Retrieving the COM class factory for component with CLSID {4DDCFF78-BFD6-4C5F-AED9-C3D07E0E92D5} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).
Trying to install directly as DOMAIN\Test fails, as it is not an admin user.
Does running the execution through a Bamboo windows agent have to be done with an admin user?