Issue: SQL Connection Error - Temporarily Change Database Type in the Registry

Issue: SQL Connection Error - Temporarily Change Database Type in the Registry

Some Microvellum users may get an error related to SQL server connection issues such as: "A connection to the factory database could not be established. Please select a different configuration."

Symptom: Toolbox starts up but freezes, and you're unable to click Start Toolbox.

  • If this is your issue, be sure to close Toolbox via Task Manager before making changes to the registry.

These steps tell Toolbox to check your local database so that you can log in and reconnect to the SQL server.

  • Left-click on "Start Menu" and type "regedit.exe."

  • Follow the path as shown for your version:

    • OEM 2016:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R7.5\Toolbox-F001:409 \Configurations\[Configuration Name]\Database Settings

    OEM 2017:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R7.5\Toolbox-0001:409 \Configurations\[Configuration Name]\Database Settings

    OEM 2018:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R18.0\Toolbox-1001:409 \Configurations\[Configuration Name]\Database Settings

    OEM 2019:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R19.0\Toolbox-2001:409 \Configurations\[Configuration Name]\Database Settings
    OEM 2020:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R20.0\Toolbox-3101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2021:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R21.0\Toolbox-4101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2022:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R22.0\Toolbox-5101:409\Configurations\[Configuration Name]\Database Settings
    OEM 2023:
    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R23.0\Toolbox-6101:409\Configurations\[Configuration Name]\Database Settings

    Toolbox Standard:

    HKEY_CURRENT_USER\Software\Microvellum\Toolbox\R7.0\Toolbox-Standard \Configurations\[Configuration Name]\Database Settings

    Micromanager/ERP: 

    HKEY_CURRENT_USER\Software\Microvellum\MicroManager\R7.0\MicroManager \Configurations \[Configuration Name]\Database Settings

    ALIS (Legacy):

    HKEY_CURRENT_USER\Software\Microvellum\ALIS\R7.0\ALIS \Configurations\[Configuration Name]\Database Settings

  • Right-click on "DataBaseType" and "Modify" – change "SQL" to "SQLCE" – restart the program.

  • Startup Toolbox, go to Toolbox Setup > Options > Data Access > Set to SQL Server and reconnect to your SQL server by DataCatalog and DataSource -- Be sure to test the connection!

      • Related Articles

      • Connecting Microvellum to an SQL Database (Unified Work Order Database)(Tutorial 3)

        This is the third in a series of tutorials presenting the steps necessary to install and configure a new SQL Server database to work within Microvellum. It focuses on how to configure Microvellum to connect to the new SQL Server databases you have ...

      • Configuring an SQL Express Database (Tutorial 2)

        This is the second in a series of tutorials presenting the steps necessary to install and configure SQL Server to work with Microvellum. This tutorial focuses on the concluding steps when configuring the new database instance you created previously ...

      • SQL Server Backups

        This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...

      • Installing SQL Server Express Edition (Tutorial 1)

        This is the first in a series of tutorials presenting the steps necessary to install and configure a new database. Later tutorials will present the steps to configure the SQL Server database instance to work with Microvellum.  We recommend the ...

      • Issue: Error Message "Common Language Runtime Detected an Invalid Program"

        Issue: When you start a Microvellum program, an error message is displayed that says, "Common Language Runtime detected an invalid program."  Solution: The value for the registry setting called LastConfig in the ApplicationSettings folder is not set ...

      • Recent Articles

      • SQL Server Backups

        This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...

      • Toolbox Release Notes | Build 25.1.0114.641

        The following release notes apply to Toolbox build 25.1.0114.641. UI Fixes Several issues were reported and discovered within the OEM 2025 user interface. The following issues have been resolved: Fig. 1: Excess commands on the tool strip being ...

      • Toolbox Release Notes | Build 25.1.102.641

        The following release notes apply to Toolbox build 25.1.102.641 Toolbox OEM 2025 Work smarter, and faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. ...

      • What’s New in Toolbox 2025 (OEM)

        Work smarter, faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. Improvements Toolbox UI Overhaul OEM 2025 introduces several updates to the appearance and ...

      • Toolbox Release Notes | Build 24.1.1206.641

        The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...