--- title: "Create the database" slug: "create-the-database" updated: 2025-08-08T08:26:09Z published: 2025-08-08T08:26:09Z canonical: "docs.grassfish.com/create-the-database" excludeFromExternalSearch: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.grassfish.com/llms.txt > Use this file to discover all available pages before exploring further. # Create the database 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] > 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. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/install-grassfish-server-software-image-w3mrj2jq.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A30Z&se=2026-10-26T12%3A33%3A30Z&sr=c&sp=r&sig=yYAPejjJZyUlW3Gd%2BylUPKh3Cb89EXACliAfNhgk0fY%3D) ## 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. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/install-grassfish-server-software-image-3d6qa41j.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A30Z&se=2026-10-26T12%3A33%3A30Z&sr=c&sp=r&sig=yYAPejjJZyUlW3Gd%2BylUPKh3Cb89EXACliAfNhgk0fY%3D) ## 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**. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/install-grassfish-server-software-image-sbeacmo8.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A30Z&se=2026-10-26T12%3A33%3A30Z&sr=c&sp=r&sig=yYAPejjJZyUlW3Gd%2BylUPKh3Cb89EXACliAfNhgk0fY%3D) 4. To run the script, select your database from the dropdown menu and click **Execute**. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/install-grassfish-server-software-image-5m97v4bx.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A30Z&se=2026-10-26T12%3A33%3A30Z&sr=c&sp=r&sig=yYAPejjJZyUlW3Gd%2BylUPKh3Cb89EXACliAfNhgk0fY%3D) 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](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/install-grassfish-server-software-image-qxlh0hql.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A30Z&se=2026-10-26T12%3A33%3A30Z&sr=c&sp=r&sig=yYAPejjJZyUlW3Gd%2BylUPKh3Cb89EXACliAfNhgk0fY%3D) ## 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**. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/install-grassfish-server-software-image-a490wobu.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A30Z&se=2026-10-26T12%3A33%3A30Z&sr=c&sp=r&sig=yYAPejjJZyUlW3Gd%2BylUPKh3Cb89EXACliAfNhgk0fY%3D) 4. In the **Password** field, enter the new password. 5. In the **Confirm password** field, enter the new password again.