Change SQL User Credentials for SQL Authentication

Database User settings can be authenticated by Windows or SQL. In case of SQL authentication, if the user name/password is changed in the SQL database then the same has to be updated using Farm Configuration Wizard. You can also use this option to switch from one authentication type to the other.

To change SQL User Credentials for SQL Authentication

1. On the Windows Start menu, point to Programs, point to AVEVA, and then click Farm Configuration Wizard.

   The AVEVA Work Tasks Farm Configuration Wizard appears.

2. Click Next.

3. Select Database Settings.

4. Click Next.

   The Connect to existing database screen appears.

5. From the Connection String option, modify the User Id and Password for connecting to the database.

6. Click Test Connection.

7. Click OK.

8. Click Next.

9. Stop the following AVEVA Work Tasks services:

   • Client Service

   • Workflow Engine

   • Task Scheduler

   • Communication Service

   • Mobile Notification Service

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 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 WorkTasksTemp 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 user credentials are updated.

See Also: Create Farm Database