Specifying Custom Locations for Metasys Server Application and Databases - Metasys - LIT-12012162 - MS-ADS05U-0 - MS-ADX100SQL2-0 - MS-ADX100U-0 - MS-ADX10SQL-0 - MS-ADX10U-0 - MS-ADX25SQL-0 - MS-ADX25U-0 - MS-ADX50SQL-0 - MS-ADX50SQL2-0 - MS-ADX50U-0 - Server - Metasys Server - 11.0

Metasys Server Installation and Upgrade Instructions

Brand
Metasys
Product name
Metasys Server
Document type
Installation Guide
Document number
LIT-12012162
Version
11.0
Revision date
2021-07-02
Product status
Active
Language
English
By default, the Metasys Server software is installed on the local disk drive, typically drive C:. Likewise, the installer creates the Metasys system databases using the SQL Server default location, also typically the C: drive. However, by following the steps in the section, you can specify a different disk location of where to install the files and databases (for example, drive E:).
Important: The Metasys Server installation can fail if you specify a drive other than C:\ with a custom path that contains parentheses, or other special characters, in the installation options for Server software. For example, the installation can fail if you specify a path like D:\Program Files (x86)\Johnson Controls.

If you accept drive C: as the location for files and databases, skip this section.

In order to install the Metasys Server application to an alternate disk drive location, use the Custom installation method. You can also install the application databases in a custom location, but to do so, you need to create the Metasys historical databases before you begin the installation by using the SQL Server Management Studio. The Metasys Server setup then detects the presence of the historical databases and installs the databases at that location.

Note: Even if the existing databases were created in a specified location at an earlier release, the JCIReportingDB and SpacesAuthorization databases are created in the SQL Database Properties default location.

The following table indicates the application and database default locations.

Table 1. Default Application and Database Locations

Installed Item

Default Location

Metasys Server Application

C:\Program Files (x86)\Johnson Controls\MetasysIII on a 64-bit system

Metasys System Databases1

C:\Program Files\Microsoft SQL Server\MSSQL<version>.MSSQLSERVER\MSSQL\DATA

Follow these steps to create the databases at a custom location. (For more background on changing SQL Server database default locations, browse to this link: https://msdn.microsoft.com/en-us/library/dd206993(v=sql.120).aspx).

  1. Install the version of SQL Server software that is recommended for your operating system and supported for Metasys software on the alternate disk drive. You can use the SQL Installer tool to specify a custom install path. For details, see SQL Server Software.
  2. If you installed one of the full versions of SQL Server software, skip to the next step. If you installed a version of SQL Server Express, verify if you also have SQL Server Management Studio under the SQL Server program group. If that application is not on the computer, install the SQL Server Management Studio software on the drive that you just installed SQL Server software. For details, refer to the SQL Server Software Installation and Upgrade Guide (LIT-12012240) .
  3. Start SQL Server Management Studio. Log in as the SQL Server sa administrator, or with a Windows user account that has administrative rights to SQL Server. The Object Explorer appears.
  4. Use Object Explorer to manually create the following system databases on the alternate disk drive one at a time:

    JCIAuditTrails, JCIEvents, JCIHistorianDB, JCIItemAnnotation, JCIReportingDB, SpacesAuthorization, and MetasysReporting

  5. When you define the database, assign the Owner as <default> and specify a custom location in the Path field. Use the browse button next to each path field to locate where you wish to create the database.
    Figure 1. Example of Defining JCIAuditTrails Database

  6. Save the new database.
  7. Repeat for each Metasys system database listed in Step 4.
  8. Create an empty folder structure for the third-party components under which you intend to install the Metasys Server software as follows: <alternate path>\Program Files x86\Johnson Controls\Third Party Packages

    For example: E:\Program Files x86\Johnson Controls\Third Party Packages

  9. Install the Metasys Server application using the Custom method. In the Install Path field, specify the alternate disk drive in the installation path (for example, E:\Program Files x86). For a unified ADS or ADX, the setup locates, then uses the new databases that you have created. For a split ADX, you select on the installation screens where you placed the databases.
1 Prior to Release 8.0, the databases were created here by default: C:\ProgramData\Johnson Controls\MetasysIII\SQLData