Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
'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?
해결 방안
1. Check the ToadAutoObject in DCOMCNFG
2. Go to the Security tab and ensure the connected user has all permissions ticked (Local Launch, Remote Launch, Local Activation, Remote Activation)
3. Go to the Identity tab and change the identity of the ToadAutoObject in DCOMCNFG to be 'This User' and specify the connected user and password with all permissions granted.