Toad World® Forums

TIC automation

Hi everyone.

I have a automation script running in TIC, and it fails to pick up the automation file from a network folder. The error message states access to the file is denied.

I am running TIC on Win7. Any thoughts?

Thanks.

When the automation script runs on TIC it is run under the system account. This account does not have the same privileges as you do. We will be adding the ability to change this account in TDP 3.6.

For now you might consider running the service under your account. To do this change the logid for the ToadBIAppServer service.

AppSerer.png

Hi TDP_OWL,

Here is an exerpt from the Toad Data Point Help explaining how to change the account under which Intelligence Central (TIC) runs.

Automation Scripts Run Under TIC Local System Account

When executing scripts on a Toad Intelligence Central server, Toad uses the server’s Local System user account by default. For best results, give this account all the necessary permissions to successfully execute Automation scripts on Intelligence Central.

Alternative to Local System Account

If it is not possible to grant the server’s Local System account the necessary permissions to run all Automation scripts successfully, an alternative is to configure Intelligence Central to run under another account that does have the correct permissions. If you use this workaround, configure these three services: Toad BI App Server, Toad Intelligence Central, and Toad Intelligence Central Proxy.

To run Intelligence Central under a different account

  1. Open the Windows Local Services manager (example in Windows 7 environment):

Control Panel > System and Security > Administrative Tools > Services (Local)

  1. Or click the Start button, enter services.msc in the Search field, and press Enter.
  2. In the Services manager window, right-click Toad BI App Server and select Properties.
  3. In the Properties dialog, select the Log On tab.
  4. Select This account and enter the user name and password for the alternative account with necessary permissions.
  5. Click OK to save your modifications and close the dialog.
  6. Repeat for Toad Intelligence Central and Toad Intelligence Central Proxy.
  7. Then restart each service to apply the changes.
    You can also find these instructions in the Toad Data Point Online Help.