Editing SQL user information

Edit Microsoft 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 is installed on every server where Automation 360 is running.

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

Users must make changes to the running configuration via the command-line interface.

Procedure

  1. Open the command line prompt and navigate to the Automation 360 application.
    For example, C:\Program Files\Automation Anywhere\jdk11\bin.
  2. 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.
  3. Restart the Automation 360 services on the nodes.
The SQL user information is successfully updated.