Adding the Metasys Advanced Reporting System to an Existing ADS/ADX - Metasys - LIT-12012162 - MS-ADS05U-0 MS-ADX10U-0 MS-ADX10SQL-0 MS-ADX25U-0 MS-ADX25SQL-0 MS-ADX50U-0 MS-ADX50SQL-0 MS-ADX50SQL2-0 MS-ADX100U-0 MS-ADX100SQL2-0 - Server - Metasys Server - 12.0.50

Metasys Server Installation and Upgrade Instructions
Product
Building Automation Systems > Application Servers > Metasys Server
Document type
Installation Guide
Document number
LIT-12012162
Version
12.0.50
Revision date
2023-10-12
Product status
Active
Note: When you install or upgrade an ADS or ADX computer, you can add support for the Metasys Advanced Reporting System during the normal installation sequence if you have an ADX (or an ADX that was upgraded from an ADS) and SQL Server software that is supported by Metasys software with SQL Server Reporting Services. After you install an ADX without the Metasys Advanced Reporting System, you cannot go back and add support for the Metasys Advanced Reporting System without reinstalling the ADX software. Also, after you install the Metasys Advanced Reporting System, it cannot be uninstalled separately using the Add/Remove Programs procedure in Windows.

When in doubt, upgrade your entire system and add SQL Server software that is supported by Metasys software with SQL Server Reporting Services (SSRS) and an ADX that supports the Metasys Advanced Reporting System. For instructions, refer to the ADS/ADX Commissioning Guide (LIT-1201645) .

To add the Metasys Advanced Reporting System to an ADS or ADX:

  • For an ADS, upgrade to an ADX and select the Metasys Advanced Reporting System option during installation. For instructions, refer to the SQL Server Software Installation and Upgrade Guide (LIT-12012240) .

  • For an ADX:

    • If you are using any version of SQL Server software without SQL Server Reporting Services:

      1. Back up all archive databases and all historical databases: JCIAuditTrails, JCIEvents, JCIHistorianDB, JCIReportingDB, SpacesAuthorization and JCIItemAnnotation.
      2. Uninstall the ADX software using Add/Remove Programs or Uninstall a Program. Do not retain the Metasys databases.

      3. For SQL Server 2016, you need to uninstall SQL Server software, restart the computer, then reinstall SQL Server software including the supported service pack, making sure you add the Reporting Services component.

        For SQL Server 2017, you can install SQL Server Reporting Services from the SQL Server Installation Center.

      4. Install the ADX software with Metasys Advanced Reporting System support.
      5. Restore all archive databases and historical databases.

    • If you are using SQL Server software with Reporting Services, uninstall the ADX software using Add/Remove Programs or Uninstall a Program (retaining the databases), then reinstall the ADX software with Metasys Advanced Reporting System support. If you have a split ADX, make sure you have the SQL Server software components installed correctly on all computers. The SCT database can use any version of SQL Server software that is supported by Metasys software.

For steps to install the ADX for Metasys Advanced Reporting System support, see Metasys Server Software.