Editing SQL user information

Edit MS-SQL configuration related settings, including username, password, database server name, database server IP and port numbers.

Prerequisites

To perform the task, you must have a Control Room administrator account with the required rights and permissions.

Download the latest Control Room utility and make certain this utility installed on every sever where Automation 360 is running.

Note:

Users are required to make changes to the running configuration via the command line interface.

Note: Please stop all Automation 360 services on all nodes where a Control Room is installed before performing this task.

Open the command line prompt and navigate to the Automation 360 application.
For example, C:\Program Files\Automation Anywhere\jdk11\bin.
Follow the prompts from the utility to select the SQL database and enter the required credentials.

Note: The password will not be displayed on the console
Restart the Automation 360 services on the nodes.
The SQL user information has been successfully updated.