During the ADX installation or upgrade process, you can add support for the Metasys Advanced Reporting System if you have the ADX installation file and the supported SQL Server software with SQL Server Database Services and Reporting Services. After you install an ADX, you cannot go back and add support for the Metasys Advanced Reporting System without reinstalling the ADX software.
The Metasys Advanced Reporting System supports unified ADX and split ADX installations.
- Unified ADX with SCT on the ADX computer
- Split ADX with SCT on a third, separate computer
Consider the following for the Metasys Advanced Reporting System:
Because the SCT database used by the reporting system is specified during the ADX installation, you must create it before you install the ADX software. The database does not need to contain configuration information, but it must contain a Site object. The SCT database can be a restored backup generated on a different system or an empty database created through SCT.
- The computer that hosts Metasys Advanced Reporting System must be a server-class operating system and must have a supported SQL Server software version installed. The Metasys Advanced Reporting System is not supported on a computer with SQL Server Express software.
After the ADX software is installed, you can replace the SCT database with a different database, but you must use the same archive name. Refer to the ADS/ADX Commissioning Guide (LIT-1201645) for details. To rename the database referenced by the reporting system, make the database changes, uninstall the ADX software, and reinstall the ADX software, pointing to the new database.
If you have a unified ADX, the SCT must be installed on the ADX computer that has the Metasys Advanced Reporting system. The local SCT database provides the All Items and user view trees for the reporting system.
If you have a unified ADX, you must install SQL Server software with Database Services and Reporting Services on the ADX computer.
If you have a split ADX, you must install Database Engine Services of SQL Server software on the database server computer and Reporting Services of SQL Server software on the web/application server computer. You must have the appropriate SQL Server software licensing to perform installation on multiple computers. Refer to the ADS/ADX Commissioning Guide (LIT-1201645) for licensing information.
If you have a split ADX, the SCT computer can have any SQL Server or SQL Server Express software installed that is supported by the Metasys software.
If you have a split ADX, you must perform specific configuration procedures after installing SQL Server software. Refer to the SQL Server Software Installation and Upgrade Guide (LIT-12012240) .
- You cannot add the Metasys Advanced Reporting System during an upgrade if it wasn't configured and installed during the initial installation of the ADX. Ensure you follow all steps included in the installation documentation when configuring the SQL Server software and the initial installation of ADX. During an upgrade installation, if you are not prompted to configure the Reporting feature, you must uninstall the ADX, verify the SQL Server software configuration, and then install the ADX.