Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Work Tasks

Change Database Settings

  • Last UpdatedJun 06, 2024
  • 2 minute read
  1. On the Windows Start menu, point to Programs, point to AVEVA, and then click Farm Configuration Wizard.

    The AVEVA Work Tasks Configuration Wizard appears.

  2. Click Next.

    The Edit AVEVA Work Tasks Farm Settings screen appears.

  3. Select Database Settings.

  4. Click Next.

    The Connect to existing database screen appears.

  5. Modify the Authentication Type or Advanced Settings.

    If SQL Server authentication is selected, you have to key in the user name and password.

  6. Click Test Connection to ensure database connectivity.

  7. Click OK.

  8. Click Next.

  9. Stop the following AVEVA Work Tasks services:

    1. Client Service

    2. Communication Service

    3. Task Scheduler

    4. Mobile Notification Service

    5. Workflow Engine

  10. In an Enterprise Server system, ensure to stop the Advance Server service.

  11. In a client computer, ensure to stop the Client Service.

  12. In a client machine which is connected to an Enterprise Server, ensure to stop both the Advance Server service and Client Service.

  13. Close all AVEVA Work Tasks related sites and applications.

  14. To stop IIS, run Command Prompt as an Administrator, and type iisreset /stop.

  15. Delete the WorkflowManagementTemp folder from C:\Windows\Temp.

  16. Delete the AVEVA Work Tasks Cache files and folders from C:\Windows\Microsoft.NET\Framework64\v4.0.XXXXX\Temporary ASP.NET Files\.

  17. Start the AVEVA Work Tasks related services.

  18. To start IIS, run Command Prompt as an Administrator, and type iisreset /start.

The following table provides information on the various fields used in Connection String.

Field Name

Description

Authentication Type

This field is used to provide information on the process used to validate a user. AVEVA Work Tasks supports both Windows and SQL server authentication process. Example: Windows.

User ID

This field is used to enter the SQL user ID for SQL Server type of authentication. For Windows Authentication, this field appears disabled.

Password

This field is used to enter the password for SQL Server type of authentication. For Windows Authentication, this field appears disabled.

Advanced Settings

This is an optional field. It is used to enter any additional connection information such as connection Timeout etc. Example: Connection Timeout = 20.

Related Links
TitleResults for “How to create a CRG?”Also Available in