---
title: "Update the server"
slug: "update-server"
tags: ["Server"]
updated: 2025-08-20T13:56:19Z
published: 2025-08-20T13:56:19Z
canonical: "docs.grassfish.com/update-server"
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.

# Update the server

You can use the installer to update the server to the latest version. To do so, perform the following steps:

- [Backup your system](/grassfish/docs/update-server#backup-your-system)
- [Update the database](/grassfish/docs/update-server#update-the-database)
- [Create the reporting gateway database](/grassfish/docs/update-server#create-the-reporting-gateway-database)
- [Update the server software](/grassfish/docs/update-server#update-the-server-software)

> [!NOTE]
> Note
> 
> Updating the server version doesn’t update the player versions.

## Backup your system

Perform a complete backup of your system so that you can revert to a previous server state in the event of an error.

## Prepare the installation

Before installing the latest server version, ensure that you stop all application pools and Windows services. Don’t forget to restart them after the installation.

## Update the database

How you update the database depends on your IXM One version:

****Version 12.0 or later****

> [!NOTE]
> Note
> 
> You may encounter issues when using the database migrator with SQL Express. In this case, we recommend updating the database manually as in versions prior to 12.0.

**Prerequisites**

Before you begin, make sure that the database server can access the backend server and that the master.config file is shared.

If that’s not possible, you can specify the connection string manually. For example:

`.\DbMigrator.exe -c "Server=(local);Database=example;Integrated Security=true;TrustServerCertificate=True;"`

```plaintext
❯ .\DbMigrator.exe --help
USAGE:
    DbMigrator.exe [OPTIONS]

OPTIONS:
    -h, --help                                     Prints help information
    -c, --connection-string <CONNECTION_STRING>    The connection string to the database
    -m, --master-config <MASTER_CONFIG>            The master config file
    -d, --directory <SCRIPT_DIRECTORY>             The directory containing the db scripts
        --sqlcmd                                   The sqlcmd executable to use
        --unattended                               Run in unattended mode
```

**Update the database**

Starting with version 12.0, you can use a database migrator to easily update the database. Perform the following steps:

1. Open a terminal.
2. Navigate to the **DB** folder.
3. Run `DbMigrator.exe`.
4. Specify the path to the master.config file, including **master.config** at the end. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/image-1754300491202.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)
5. Select `Apply migration`. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/image (3).png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)...
6. This starts the migration. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/image (4).png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)
7. Wait until the migration was successful. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/image (5).png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)

****Versions prior to 12.0****

To update the database, perform the following steps:

1. Open SSMS.
2. Connect to the SQL Server that hosts the Grassfish database.
3. To locate the current database version, select the database from the dropdown menu.
4. Click on **New Query**.
5. Run the following SQL query: `select * from gblVersion` ![Graphical user interface, text, application, email Description automatically generated](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/update-grassfish-server-image-pyxi7ci1.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)
6. In the **Results** tab, check the **currentVersion**. You need to know it for the following steps.
7. Open the file MultiMigrationScript.sql located in the **DB** folder in the server installation folder.
8. Edit the script as shown in the following image: ![A picture containing text Description automatically generated](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/update-grassfish-server-image-n74lu8r2.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)
9. In the **Query** menu, select **SQLCMD Mode**.
10. To run the script with the Grassfish database, select the database from the dropdown menu and click **Execute**. ![](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/update-grassfish-server-image-4jvtyb81.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)
11. Open the All_SP_Trigger.sql file located in the **DB** folder in the server installation folder.
12. To run the script with the Grassfish database, select the database from the dropdown menu and click **Execute**.
13. Open your configuration setting files located in the **DB** folder and run them with the Grassfish database.

## Update the server software

You can now update the IXM Server software.

### Prerequisites

If you update from version 11.17 or later to 12.0 or later, you must ensure that **;TrustServerCertificate=True** is included in all connection strings.

```xml
<add key="DB:default" value="Server=GRASSFISH02\SQLEXPRESS;Database=GV2_Base;User ID=globalVision;Password=Secret;TrustServerCertificate=True"/>
<add key="DB:ReportData" value="Server=GRASSFISH02\SQLEXPRESS;Database=GenericReporting;UserID=globalVision;Password=Secret;TrustServerCertificate=True"/>
```

### Update the server

To update the server software, perform the following steps:

1. Stop all Grassfish-related application pools and Windows services.
2. Right-click on the file Grassfish IXM Server and select **Run as administrator**.
3. Select the install path. ![Graphical user interface, website Description automatically generated](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/update-grassfish-server-image-g0k78nxb.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)
4. Click **Next**.
5. Manually adjusting the features is usually not necessary, as the existing features are retained during an update. Simply click **Next**.

![Graphical user interface Description automatically generated](https://cdn.document360.io/e2b87f73-d9f5-43cb-8182-2641762664fd/Images/Documentation/update-grassfish-server-image-tup4t4p4.png?sv=2026-02-06&spr=https&st=2026-10-26T11%3A33%3A31Z&se=2026-10-26T12%3A33%3A31Z&sr=c&sp=r&sig=jqD7lfGR8xhZ%2BxEw5tynaoB35tTsGJ8Wcffli7ANqsc%3D)
6. Click **Next** until you’ve reached the final installation window.
7. Select **Install**.
8. Once the software update is complete, close the installer.
9. Restart your application pools and services.