When writing the Software Meter database to SQL, the following error appears. "An error occurred while saving to backend [Save to Local] [Don't Save] [Cancel]" (This can occur with other databases as well.)
A default Microsoft SQL Server (7 / 2000) installation will NOT set up the case sensitive string comparison. This causes problems when a netOctopus Administrator saves data to the SQL Server.
The option for case sensitive string comparison can be set only during a custom MS SQL Server installation, but not during a default installation. This option cannot be changed after the installation.
For the detailed explanation, please see the following note in MSDN Library\Microsoft SQL Server\ How to Install SQL Server 2000 section:
"How to create a case-sensitive instance of SQL Server 2000 (Setup)" The URL is:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_90s2.asp
For more reference please, see SQL Server Books Online:
Installing SQL Server\Collation Settings in Setup
Installing SQL Server\Windows Collation Sorting Styles