Create the database

  • Updated on Aug 8, 2025
  • Published on Jul 28, 2025
  • 3 minute(s) reading time
Prev Next

This article explains how to create the required databases for the IXM Server installation.

System requirements

To get all required installation files, go to the following directory: C:\GrassfishSourcen

All server functions like database, web, file, and backend server are installed on one server. The instructions refer to the following server configuration:

Component

Description

Storage

HD drive C:

SQL Server

  • MS SQL Server 2019 Express

  • Server name: (local)\SQLExpress

  • SQL user: globalVision

  • Default password: ABC123! (The default password must be changed after the first login.)

Server URL

http://vmsrva

Note

We recommend securing the server after the installation of the IXM Server application.

Prerequisites

Before creating the database, ensure that you meet the following requirements:

  • You’ve downloaded the server installation ZIP file to your computer and unzipped it to a location of your choice.

  • You’ve located the GV2_Base_Create.sql and CreateGenericReportingDB.sql files in the DB folder of the server installation folder.

  • Your logged-in user has access to the database server as a server system administrator or as an SQL user with the required access rights.

Open files in SSMS

When you first open a file in SSMS, you may see a dialog about inconsistent line endings.

You can choose whether or not to normalize line endings. This does not affect the server installation.

Modify the create database script

You must adjust the database script GV2_Base_Create.sql in line with your installation requirements and server system.

Perform the following steps:

  1. Open the file GV2_Base_Create.sql in SSMS.

  2. Set CreateCustomer to true. This specifies that a client should be created during the installation.

  3. Set CustomerCode to the login code for the new client.

  4. Set CustomerName to the client surname.

  5. Set DatabaseName to the name of the database to create.

  6. Set DefaultDataPath to the path where the database is stored:

    • You must use an existing path name and the SQL Server must have write access.

    • The path must not be in the installation directory of the IXM Server.

  7. Set DefaultLogPath to the path where the log file is stored:

    • You must use an existing path name and the SQL Server must have write access.

    • The path must not be in the installation directory of the IXM Server.

Modify the reporting script

You must adjust the database script CreateGenericReportingDB.sql for your installation.

Perform the following steps:

  1. Open the file CreateGenericReportingDB.sql in SSMS.

  2. Set DatabaseName to the name of the database that you want to create.

  3. Set DefaultFilePrefix to the prefix of the file name for the database files (.mdf / .ldf).

  4. Set DefaultDataPath to the path where the database is stored:

    • You must use an existing path name and the SQL Server must have write permission.

    • The path must not be in the installation directory of the IXM Server.

  5. Set DefaultLogPath to the path where the log file is stored:

    • You must use an existing path name and the SQL Server must have write permission.

    • The path must not be in the installation directory of the IXM Server.

  6. Set UserLogin to the SQL login that you’re using.

Create the database

To create the database with SSMS, perform the following steps:

  1. Run SSMS and log on to the server.

  2. Open the file GV2_Base_Create.sql.

  3. In the Query menu, select SQL CMD Mode.
     

  4. To run the script, select your database from the dropdown menu and click Execute.
     

  5. Open the file CreateGenericReportingDB.sql.

  6. In the Query menu, select SQLCMD Mode.

  7. To run the script, select your database from the dropdown menu and click Execute.

Import the player configuration

To import the player configuration via SSMS, perform the following steps:

  1. Start SSMS and log onto the server.

  2. Open the config setting script from the DB folder in the server installation folder and run it with the new Grassfish database.

A screenshot of a computer  Description automatically generated with medium confidence

Modify the SQL user password

In the process of the database creation, the system creates a user with the name globalVision. The application uses this user to access the database.

To change the user password, perform the following steps:

  1. In SSMS, go to Object Explorer > Security > Logins.

  2. Right-click on the user globalVision.

  3. From the context menu, select Properties.
     

  4. In the Password field, enter the new password.

  5. In the Confirm password field, enter the new password again.