Install or Upgrade Database Components

Install or Upgrade the Database Component in EMS Workplace / Campus / Enterprise / Legal / District

  1. Get the EMSAPIScript_WebService.sql file.

  2. Open Microsoft SQL Server Management Studio.

  3. Within Microsoft SQL Server Management Studio, select File > Open > File… and locate
    EMSAPIScript_WebService.sql.

  4. Select your EMS database and execute the query (Query > Execute). When query execution has completed, the message "Command(s) completed successfully" displays in the Results section.

Install or Upgrade the Database Component in EMS Professional

Contact your Professional Services Consultant or Customer Support.

Contact Customer Support

  • Option 1 (Recommended): Go to to search the Knowledge Base or submit a case.

  • Option 2: Email emssupport@accruent.com.

  • Option 3: Phone (800) 288-4565.