Edit Database page (Database page)

Choose between Default internal database or This external database to activate a database.

NOTE: If the {{csr}} and {{corpr}} {{epotm}} databases share the same SQL
Server instance, you must configure separate databases for each

If you choose to use an external database, the Database settings value box becomes active to
enter setting information such as the address, port, and logon details. A checkbox to enable SSL
connection to the database is also available.

Displays whether the database connection is online or offline.

When you set the database to offline, the Advanced button is no longer available.

SQL Opens a window that enables a reporting administrator to provide and execute SQL statements. Use
this function for troubleshooting when working with technical support.

Enter the username and password before using the Execute SQL option.

Provides the option to partition your schema.

NOTE: If you are not sure what partitioning is, or if you need it, do not partition your schema.

Displays this database status information:

• Availability — Displays whether the database is connected or offline.
• Schema version — Displays the connected report database schema version.
• Partitioning — Displays if partitioning is supported for:
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2019

NOTE: From Microsoft SQL Server 2016 (13.x) SP1 and above Table and index partitioning is
supported across all edition and below this version, it is only supported in enterprise edition.

• MySQL 5.5
• MYSQL 5.6
• MYSQL 5.7

Permissions — Displays the SQL permissions for the user specified in the Logon name field on the
Database page.