Change Database Settings
- Last UpdatedJun 06, 2024
- 2 minute read
-
On the Windows Start menu, point to Programs, point to AVEVA, and then click Farm Configuration Wizard.
The AVEVA Work Tasks Configuration Wizard appears.
-
Click Next.
The Edit AVEVA Work Tasks Farm Settings screen appears.
-
Select Database Settings.
-
Click Next.
The Connect to existing database screen appears.
-
Modify the Authentication Type or Advanced Settings.
If SQL Server authentication is selected, you have to key in the user name and password.
-
Click Test Connection to ensure database connectivity.
-
Click OK.
-
Click Next.
-
Stop the following AVEVA Work Tasks services:
-
Client Service
-
Communication Service
-
Task Scheduler
-
Mobile Notification Service
-
Workflow Engine
-
-
In an Enterprise Server system, ensure to stop the Advance Server service.
-
In a client computer, ensure to stop the Client Service.
-
In a client machine which is connected to an Enterprise Server, ensure to stop both the Advance Server service and Client Service.
-
Close all AVEVA Work Tasks related sites and applications.
-
To stop IIS, run Command Prompt as an Administrator, and type iisreset /stop.
-
Delete the WorkflowManagementTemp folder from C:\Windows\Temp.
-
Delete the AVEVA Work Tasks Cache files and folders from C:\Windows\Microsoft.NET\Framework64\v4.0.XXXXX\Temporary ASP.NET Files\.
-
Start the AVEVA Work Tasks related services.
-
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. |