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

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\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.ls

   Script as SA or a privileged user.