Specifying Custom Locations for OAS Application and Databases - Metasys - LIT-12013222 - M4-OASHIST-0 - M4-OASMIN-0 - M4-OASMIN-6 - M4-OASMIN-SC3 - M4-OASMIN-SCS - M4-OASPPA-0 - M4-OASSCHRPT-0 - M4-OASSTD-0 - M4-OASSTD-6 - M4-OASSTD-SC3 - M4-OASSTD-SCS - Server - Open Application Server - 12.0

Open Application Server (OAS) Installation Guide
Product
Building Automation Systems > Application Servers > Open Application Server
Document type
Installation Guide
Document number
LIT-12013222
Version
12.0
Revision date
2022-05-20
Product status
Active
By default, the OAS 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 OAS 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 OAS application to an alternate disk drive location, you need to specify that location using SQL Server Management Studio before you begin the OAS installation. The OAS 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, refer to the SQL Server Software section in Metasys Server Installation and Upgrade Instructions (LIT-12012162) .
  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 OAS application. The installer creates the Metasys databases in the custom disk drive location that you specified in step 4.
1 Prior to Release 8.0, the databases were created here by default: C:\ProgramData\Johnson Controls\MetasysIII\SQLData