Installation of a Microsoft SQL Database

enaio® coLab • 11.10 »

enaio® coLab can also be operated with a database on a Microsoft SQL server. In most cases, this makes it possible to use the same database server as for enaio®.

Please note that there is no support for migration from one database to another.

To activate Microsoft SQL Server support in enaio® coLab, follow these steps

Microsoft SQL Server 2008 or higher is installed.

  1. Create a new user with a password on the Microsoft SQL server.

    The user name can be "colab". Select a secure password.

  2. Create a new database named "colabdb" with a user named "colab" as the owner.

  3. Change colab-prod.yml by adding new sections under the spring: configuration as follows:

    spring:
      datasource:
        url: jdbc:sqlserver://db_server_ip;databaseName=colabdb;trustServerCertificate=true;
        username: colab
        password: 
        driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
      jpa:
        properties:
          hibernate:
            dialect: org.hibernate.dialect.SQLServerDialect
      liquibase:
        contexts: legacy