Database installation - Johnson Controls - LIT-12013270 - Software Application - Companion - 1.1

Companion Installation Guide

Johnson Controls
Product name
Document type
Installation Guide
Document number
Revision date

About this task

To install the Companion database, complete the following steps:


  1. Open SSMS.
  2. From the Authentication list, select SQL Server Authentication.
  3. In the Login field, enter your details.
  4. In the Password field, enter your password.
  5. Click Connect.
  6. From the installer package, double-click CompanionScript.sql to add the contents to the Query Editor in the SSMS.
  7. From the SSMS, click New Query, and copy and paste the contents from the CompanionScript.sql file.
  8. From the Query Editor, click Execute.
    You can also click Run Query from the toolbar, or press F5 on your computer keyboard to execute the file. You receive a notification on your screen with the message Query executed successfully when the execution is complete.


To check that the database is installed on your computer, complete the following steps:
  1. From the database window, click View, and then click Object Explorer.
  2. From the Object Explorer window, expand the Databases tab, and Companion should be listed as one of the databases.