- Updated: 2023/03/29
View the list of supported databases, database server type, version, hardware, and operating system requirements, and database backup and recovery requirements.
For latest updates, see Microsoft SQL Server Hardware and Software requirements.
Database server hardware requirements
4-core Intel Xeon Processor with 2.5 GHz plus speed
|8 GB||500 GB||1 GbE|
Database server version and operating system requirements
|Database type||Database version||Database edition||Installed OS||Supported platforms||Configuration requirement|
|Microsoft SQL Server database||
||Amazon Web Services Relational Database Service (RDS)||
Installed and configured.
Only option for Express installations.
Enable protocols for Named Pipes and TCP/IP.
|Oracle Server database||Oracle 19c||
||Amazon Web Services Relational Database Service (RDS)||Installed and configured with max_string_size parameter set to EXTENDED. Supported only on non-container Database. Available only through an On-Premises custom installation.|
- All database versions support all certified operating systems.
- We have certified Amazon RDS for SQL Server and Azure SQL single database for
Note that 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|
|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. Do not use semicolons ( ; ) in the database password.
SQL Database server Login ID:
SQL Database password:
sa user authentication is mandatory.
Database names cannot be blank, have spaces, or include a percent ( % ). Restrict the names to alphanumeric, period ( . ), hyphen ( - ), and underscore ( _ ).
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.|
Provide the user with
The preferred method is to use the Domain user account.
The Windows credentials of the user logged in to the device to connect to the database server.
|Database collation||Use the default database collation:
For Oracle Server database information, see Installing Control Room using custom mode for Oracle installation.
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.