SQL Server considerations - Johnson Controls - LIT-12012585 - Software Application - JEM: Johnson Controls Enterprise Management - 1.3.1

Metasys Enterprise Management Professional Productivity Tool (PPT) Guide
Product
Building Automation Systems > Building Automation Systems > Johnson Controls Enterprise Management
Document type
User Guide
Document number
LIT-12012585
Version
1.3.1
Revision date
2018-12-11

When using the Professional Productivity Tool, you must consider the following regarding the server:

  • If you do not already have SQL Server on your computer, you must install it with mixed mode authentication.
  • If you are an advanced user, you may install multiple-named instances of SQL Express on your computer and access these individually for different projects. This is useful if you share PPT for JEM project files but you cannot downgrade the SQL database.
  • We recommend you change the SQL Server maximum memory to 2GB. To do this, use SSMS (SQL Server Management Studio) to complete the following steps:
    1. Connect to your Server.
    2. Right-click on the Server instance under Object Explorer.
    3. Select Properties.
    4. Select Memory under Select a page.
    5. Select 2048 in the Maximum Server Memory (in MB) setting.
    6. Click OK.
    7. Close SSMS.