Database settings
GFI Archiver requires SQL Server® (if used as the archival database) to be installed in case insensitive mode. This is the default installation setting of SQL Server®. The SQL Server® collation modes apply to all SQL Server® objects including login names. In such cases if a user changes a property in the name and does not make EXACT character case matches, GFI Archiver will fail since it would not find the resources required.
Once installed, it is not possible to change the SQL Server® collation mode easily. It requires a rebuild of the master database using advanced Microsoft® SQL tools or methods. The best solution is to install another instance of SQL Server® (set to operate in insensitive collation mode).
IMPORTANT
Ensure SQL Server® is installed in case insensitive mode if SQL Server® is used as the archival database.
See also: