Database requirements

View the list of supported databases, database server type, version, hardware, and operating system requirements, and database backup and recovery requirements.

Automation Anywhere installation creates a database to store bot data and metadata for the analytics dashboards.
Note: Automation Anywhere does not provide any monitoring functions for database activities, such as disk space usage, memory, or other alert mechanisms related to databases. There are commercial tools available from database vendors and other third-party independent software vendors (ISV) who provide such tools.

For latest updates, see Microsoft SQL Server Hardware and Software requirements.

Database server hardware requirements

Component server Processor RAM Storage Network
Database server

4-core Intel Xeon Processor with 2.5 GHz plus speed

 8 GB 500 GB 1 GbE
Note: If you are hosting the Control Room databases along with other application databases, ensure that the hardware resources are increased proportionately.

Database server version and operating system requirements

Database type Database version Database edition Supported Operating system Supported platforms Configuration requirement
Microsoft SQL Server database
  • 2022
  • 2019
  • 2017
  • 2016
  • 2014
  • Enterprise
  • Standard
  • Developer (for 2019)
  • Microsoft Windows Server:
  • 2022 Standard and Datacenter
  • 2019 Standard and Datacenter
  • 2016 Standard and Datacenter
  • Linux CentOS 7.7, 7.9 and 8.3
  • Red Hat Enterprise Linux 7.7 and 7.9
  • Amazon Web Services Relational Database Service (RDS)
  • Azure SQL single database for PaaS

Installed and configured.

Only option for Express installations.

Enable protocols for Named Pipes and TCP/IP.

  • Support for Microsoft SQL Server 2022 is only available on Automation 360 v.34 or later versions.
  • All database versions support all certified operating systems.
  • We have certified Amazon RDS for SQL Server and Azure SQL for PaaS database on standalone deployment.
    Note: Whether you use Amazon RDS for SQL Server or Azure SQL, ensure that you configure a single dedicated database for the Control Room.
    Note: For Azure SQL, CPU or memory requirements are not applicable because it is a scalable and high performance Cloud database built on similar lines with SQL Server and certified for PaaS deployment in Automation 360.
  • We recommend hosting the databases on separate hosts to take into account failover scenarios.
  • We recommend Enterprise or Standard editions of Microsoft SQL Server database for production use and to ensure business continuity with HA and DR deployments.

    You can configure the Express edition of Microsoft SQL Server for Automation 360 testing and proof of concept (POC) purposes based on considerations such as limit on data size, SQL agent unavailability, and DR capabilities.

    For more information about scale limits, see Microsoft SQL Server Express edition scale limits.

  • Transparent Data Encryption (TDE) is a function of Microsoft SQL Server database. Additional configurations are not required on the Control Room as the TDE supportability is managed by Microsoft. For more information, see Transparent data encryption (TDE) and Transparent data encryption for SQL Database.

Required database information for Automation Anywhere installation

When you install Automation Anywhere, you are prompted to provide information specific to the database type you are using. The following table summarizes the required information.

Microsoft SQL Server database
Required information Description
Database (SQL Server) authentication
Note: Linux installations use this authentication method

Provide credentials for a Microsoft SQL Server user who has permission to connect to the database.

Use only supported characters for the authentication user name and password. See Supported special characters in usernames and passwords. Do not use semicolons ( ; ) in the database password.

Linux example:

SQL Database server Login ID: sa

SQL Database password: Automation123

sa user authentication is mandatory.
Database names

Database names cannot be blank, have spaces, or include a percent ( % ). Restrict the names to alphanumeric, period ( . ), hyphen ( - ), and underscore ( _ ).

Default name: Automation360-Database

Database port Default: 1433

Connection to this port is mandatory.
Secure connection (optional) and certificate Provide a CA certificate. Ensure the certificate host name and database connection are the same.
Service credentials

Provide the user with db_datareader, db_datawriter, and db_ddladmin permissions to create databases during installation.

The preferred method is to use the Domain user account.
Windows authentication

The Windows credentials of the user logged in to the device to connect to the database server.
Database collation Use the default database collation: SQL_Latin1_General_CP1_CI_AS

Before installing Automation 360, ensure that you have configured additional firewall settings, verified the connection to the default port and an SQL query with SA user works as expected.