Overview

Umango installations include Microsoft SQL Server 2017 Express as a prerequisite for database functionality. In some environments, the installation of SQL Server 2017 Express may fail, preventing Umango from installing successfully.

This article explains the cause of the issue and provides a recommended workaround.

Problem

During the Umango installation process, SQL Server 2017 Express may fail to install. When this occurs, the Umango installer cannot proceed because the required database engine is unavailable.

Cause

SQL Server 2017 has specific hardware, operating system, and software requirements that are not compatible with all modern environments. As a result, the SQL Server 2017 Express prerequisite may fail on some systems.

Because SQL Server 2017 is an older release, compatibility issues are increasingly common on newer hardware and operating systems.

Solution

The recommended solution is to manually install a newer version of SQL Server and create the Umango database before running the Umango installer.

Recommended approach

1. Manually install a newer supported version of SQL Server
   • SQL Server 2019 Express
   • SQL Server 2022 Express
2. Create the Umango database manually.
3. Run the Umango installer and point it to the existing database.

This approach avoids compatibility issues with SQL Server 2017 while allowing Umango to install and function normally.

Steps

Step 1 - Install a newer version of SQL Server

Download and install a newer supported version of SQL Server, such as SQL Server 2019 Express or SQL Server 2022 Express.

Ensure that the Database Engine Services are installed and that the instance is ready to accept connections.

Step 2 - Create the Umango database

Create the Umango database manually before running the installer.

Follow the instructions in this article:

Installing Umango 23 with non-standard database settings

Typical steps include:

• Creating a new database for Umango
• Creating or assigning a SQL login and user
• Granting the required permissions to that user

Step 3 - Run the Umango installer

Launch the Umango installer after the SQL Server instance and Umango database have already been prepared.

When prompted for database settings:

• Select the existing SQL Server instance
• Enter the server name
• Enter the database name
• Enter the appropriate credentials

The installer will then connect to the pre-configured database instead of attempting to install SQL Server 2017 Express.

Reference

For Microsoft SQL Server hardware and software requirements, see:

Hardware and software requirements for installing SQL Server

Best Practice

For new installations, Umango recommends using a supported and current SQL Server version rather than relying on the bundled SQL Server 2017 Express prerequisite where compatibility issues may occur.