Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Configure database type and server

  • Updated: 6/18/2021
    • Automation 360 v.x
    • Install
    • RPA Workspace

Configure database type and server

Continue from the Control Room installer to the Database type wizard page. Use this page to configure the Microsoft SQL Server database for use with the Control Room.

This procedure applies only to Microsoft Windows Server based installations.

Procedure

  1. Select the Microsoft SQL Server database.
    An instance of the SQL Server should be already configured.
  2. Click Next.
    The Database Server page is displayed (if you selected SQL Server for configuring your database).
  3. Set the connection and authentication for the database server.
    Note:
    • If possible, do not set the value for Database Server as localhost. If you must use localhost, note that the Secure Connection to the database will not work.
    • Click Browse to select the SQL Server instance where the Control Room database will be created. Alternatively, enter a database server name or select one from the list.

    Migration task: If you are migrating from Enterprise 11 to Automation 360, browse to the restored Enterprise 11 database.

    Provide the following details:
    1. Database Port: Use the default port (1433) or specify a custom value.
    2. Use Secure Connection: Select to use a CA certificate as specified.
      Note: Use the same host name for certificate and database connections.
    3. Certificate: This option is enabled when you select Use Secure Connection.Browse to select a CA certificate.
    4. Select one of the following for database authentication:
      • Windows authentication: This option is selected by default and allows connection to the SQL Server using Windows authentication.
        Note: If you select Windows authentication, then the user running the installer is used to test that the database exists, create it if required, and grant db_owner to the service account user (NT Authority/System).
      • SQL Server authentication: (manually enter credential) Select this option to use SQL Server authentication to connect to the database. Provide the correct user name and password for SQL authentication.
        1. Enter username.
        2. Enter password.
      • AD Azure authentication: Select this option to use Microsoft Azure Active Directory credentials to connect to the database when you install the Control Room on Microsoft Azure.
      Use only supported characters for the user name and password. See Supported special characters. Do not use semicolons ( ; ) in the database password.
    5. Name of Control Room database: Enter the name of the Control Room database.
      Migration task: If you are migrating from Enterprise 11 to Automation 360, enter the name of the restored database in the database field as shown in the following image:

      Image displaying the restored 11.x database name when you migrate to Automation 360

  4. Click Next to provide the Elasticsearch credentials.
Send Feedback