Skip to main content

Configure the Database Connection

Kanoa MES uses a Microsoft SQL Server database connection named kanoaCore. This connection is required. Kanoa MES requires Microsoft SQL Server 2019 (15.0) or later.

Create the database connection in the Ignition Gateway​

Database Connection

In the Ignition Gateway, create a new database connection and name it:

  • kanoaCore (required name)

Reference: Connecting to Databases (Ignition 8.1)

  • The database connection name must be kanoaCore.
  • The userName and credentials used in the database connection must be a user with dbOwner privileges in order to create the kanoaMES schema, tables.
  • Set Max Active to -1 in the advanced options.
  • Recommend setting Include Schema in Table Name to true.

Schema creation and updates​

The Kanoa MES module installer handles both:

  • creation of the required database schema (on first install), and
  • updating the schema (on upgrade)

You do not need to manually create tables as part of the install process.