Setup Microsoft SQL Server - EcoSys - 2.0 - Installation & Upgrade - Hexagon

Microsoft SQL Server database prerequisites and setup.

Microsoft SQL Server Prerequisites

1. Enable the "Allow remote connections to server" setting.

EcoSys Connect Collation Support

The EcoSys Connect requires a Case Insensitive (CI) collation.

Setting Up the SQL Server Database

1. Edit the \database\create\sqlserver\setup\create.sql script:

   • If a password other than "ecuser" is used for "ecuser" login, modify the portion of the script that creates the "ecuser" login and password.

     Create Login as ECUSER with password = ecuser

2. Execute the create.sql

   Script as SA or a privileged user.

3. Apply schema updates as follows:

   1. Copy the correct JDBC jar file to the \database\upgrade folder

   2. Open the \database\upgrade\liquibase.properties file for editing

      1. Locate the SQL Server section, set the URL, username, Password, liquibaseSchemaName, and classpath based on your environment.

      2. Save the file.

   3. Open a shell on the host

   4. Change directories to \database\upgrade

   5. Ensure JAVA is on the path
      JRE 1.8 or above is required

   6. Run the command upgrade.bat

   7. The result of the command appears as follows: