Symptom
The Labels list contains only one label (e.g. Location Labels) instead of the usual eight items.
Cause
The SQL instance and database were created with a collation that MobileAsset cannot use. This can happen when the MobileAsset installation is performed on a PC where the System Locale is not set to English (United States). For example, when the System Locale is Korean, the automated SQL Server installation sets the collation to Korean_Wansung_CI_AS.
Resolution
The SQL instance and database must be uninstalled, then installed fresh so the collation can be specified correctly. Wasp Tech Support can assist with these procedures if needed.
- Export any needed data.
- Uninstall the SQL instance.
- Move the existing database files out of the SQL Data folder.
- Manually reinstall the SQL instance, specifying the SQL_Latin1_General_CP1_CI_AS collation.
- Run the database installer.
- Import any needed data.