Specifying Custom Locations for Metasys Server Application and Databases - 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
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, you need to specify that location using SQL Server Management Studio before you begin the installation. 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 default disk drive. For details, see SQL Server Software.
  2. Start SQL Server Management Studio. If your version of SQL Server software does not have Management Studio, you can download it here: https://aka.ms/ssmsfullsetup. 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.
  3. Using Object Explorer, right-click on the database instance name and select Properties Figure 1.
  4. In the Properties window, select Database Settings. Under Database default locations, specify a custom location in each of the Path fields: Data, Log, and Backup. Use the browse button next to each path field to locate where you want to create the database. Select the same disk drive for each.
    Figure 1. Example of Defining Alternate Disk Drive Locations for SQL Server Databases
  5. Click OK and exit from SQL Server Management Studio.
  6. Install the Metasys Server application. The installer creates the Metasys databases in the custom disk drive location that you specified in step 4.
1 Before Release 8.0, the databases were created here by default: C:\ProgramData\Johnson Controls\MetasysIII\SQLData