Change Database User Settings for Windows Authentication
- Last UpdatedJun 06, 2024
- 2 minute read
The database user settings can be authenticated by Windows or SQL. In case of Windows Authentication, if the user name and password is changed in Active Directory then the same has to be updated using the Farm Configuration Wizard. You can also use this option to switch from one authentication type to the other.
You need to ensure that there are no running workflows while changing database user settings.
Changing Database User Settings for Windows Authentication
-
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 User Settings.
-
Click Next.
The Database User Settings screen appears.
-
Enter the updated User Name, Password, and Domain.
-
Click OK.
A message to ensure that the login has required permissions appears.
-
Click OK.
A message indicating Database User settings edited successfully appears.
-
Click OK.
-
Stop the following AVEVA Work Tasks services:
-
Client Service
-
Communication Service
-
Task Schedule
-
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 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.
-
Click OK.