Umango Installation Issue - SQL Server 2017 Compatibility

Umango Installation Issue - SQL Server 2017 Compatibility

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.

  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.

    • Related Articles

    • Resetting The Umango Authentication Method

      Overview If the Authentication Method in Umango is misconfigured (e.g., an incorrect LDAP or MFA setup), administrators may find themselves locked out of the system. By removing the AuthenticationMethod entry from the database, Umango reverts to its ...

    • Installing Umango Silently Using Command Line Properties

      This article explains how to install Umango without user interaction by running the installer from the command line and supplying MSI properties. The Umango installer is distributed as an EXE bootstrapper that contains an MSI package. For silent ...

    • Installing the Umango Cloud Embedded App on HP MFDs

      Overview This article walks you through installing the Umango embedded app onto an HP Multi-Function Device (MFD). HP devices expose their OXPd web services over HTTPS using a self-signed certificate, which most browsers (and operating systems) ...

    • Umango Scan Actuator Troubleshooting

      This article walks you through diagnosing connection problems between the Umango Scan Actuator (the small desktop app that talks to your scanner) and the Umango web application running in your browser. If you're on a personal or home computer, start ...

    • Changing SNMP Settings in Umango

      Umango uses SNMP (Simple Network Management Protocol) to discover and interact with supported multifunction devices (MFDs) on the network. These settings can be customized via the Advanced Configuration Screen. Default SNMP Settings By default, ...