Installing Enterprise Back Office on Microsoft SQL Server

  1. Make sure Microsoft SQL Server is installed and running.
  2. Extract the following from the installation file archive in the same file structure. Do not extract the files to a folder structure that contains spaces.

    DBInstall.exe

  3. Double-click DBInstall.exe to launch the database installation wizard.
  4. On the Choose Installation or Upgrade page, select whether you are upgrading an existing database or installing a new shell database.

    If you are installing a new shell database, install a clean Microsoft SQL Server with no Reporting and Analytics objects.

  5. On the Choose Install Set page, select myMicros.
  6. On the MyMicros Database Information page:
    1. To set up the Enterprise Back Office database, select SQL Server, enter the network port used by the database server. By default, the Microsoft SQL Server uses port 1433.
    2. Fill out the rest of the form. For new installations, the form allows you to create passwords for the database users. For upgrades, enter the login credentials to the existing Microsoft SQL database server in the Upgrade login and password fields, and then enter the existing database passwords.
  7. On the SQL Agg DB Config page, set up the Enterprise Back Office database:
    1. Enter the hostname and port of the Enterprise Back Office database server.
    2. If you are performing an upgrade, in the Upgrade Login and Upgrade Password fields, enter the login credentials to the existing Microsoft SQL database server.
    3. In the Additional Connection Parameters field, enter any required connection strings.
  8. For new installations:
    1. On the Sys Admin Password page, create a password for the sys admin account for the M super organization.
    2. On the Tablespace Locations page, enter the path to the folder for storing the database tablespace files.
  9. On the MyMicros Database Information - Master page, enter the database administrator (DBA) login credentials for the Reporting and Analytics database.
  10. On the MyMicros Database Information - Aggregation Master page, enter the database administrator (DBA) login credentials for the Enterprise Back Office database.
  11. For new installations, on the Get SQL Server Aggregation tokens page, enter the path to the folder for storing the Enterprise Back Office database and the database log file.
  12. On the Pre-Installation Summary page, click Install and allow the database installation or upgrade to complete.

Verifying the Database Installation

  1. Verify that there is a versionnum entry for the Enterprise Back Office database version to which you upgraded in the following databases:
    • AGGREGATE_DB.AGG_VERSION_DB

    • BIREPOS.BIREPOS_VERSION_DB

      • Not applicable for 9.1 New Tech Stack

    • CEDB.CE_VERSION_DB

    • COREDB.CORE_VERSION_DB

    • LOCATION_ACTIVITY_DB.VERSION_DB

    • PORTALDB.PORTAL_VERSION_DB

    • QUARTZ.QUARTZ_VERSION_DB

      • Not applicable for 9.1 New Tech Stack

    • RTA.RTA_VERSION_DB

  2. Check the following logs for errors and exceptions:
    • root\temp\DBinstaller.log

    • root\temp\Logs\eBusiness_DatabaseUpgrade_Install_dateandtime.log