Catastrophic Collation Error Due to Incompatible MobiControlDB_Archive Database

The installation cannot complete due to a catastrophic database failure, and the database goes into recovery mode.

The catastrophic error is due to the collations of the MobiControlDB_Archive or MobiControlDB databases not being compatible. 

SOTI MobiControl 15.6.X to 2024.X

A catastrophic error occurs at the end of the SOTI MobiControl installation, causing the upgrade to SOTI MobiControl 2024.X to fail.

To avoid this issue, collation should be verified before running the SOTI MobiControl installer, to confirm the collation is compatible.

Refer to System requirements for database requirements.

For example, the Modern_Spanish collation is not supported. 

In this particular case, the DB uses SQL_Latin1_General_CP1_CI_AS and will continue to use this collation, therefore the SQL Server should have the same.

To resolve this issue, stop the SQL service. Then run the following query to fix the recovery:

USE MobiControlDB
RESTORE DATABASE mobicontrolDB WITH RECOVERY;
Note: Change the DB name as needed.

Note: The catastrophic error in this example is due to the collation of the MobiControlDB_Archive database not being compatible. 

Use the following query to identify the collation:

SELECT name, collation_name FROM sys.databases

Note: If the installation fails again with a different generic error, change the SOTI MobControl service to run manually and run the installer again.  At the end of the installation, change the SOTI MobControl service to not run automatically.

After successful installation, run the SOTI MobControl service manually and then change it to run automatically.