When installing the DyKnow Database Server, the following error message may appear. "Error 27506. Error executing SQL script Install01. Line 39. Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the like operation. (468)."
Note: The error may not appear verbatim to the error shown above.
This error may occur because the server needs to be running US/English Localization in the SQL Server regional settings.
There are multiple ways to resolve this error:
Reinstall SQL Server 2005
This process is generally the quicker of the two. Windows Server must be configured to be US/English localization in the regional settings before installing SQL Server 2005. Australian localization is supported in DyKnow version 5.2.
You can then install and use this as your guide for SQL Collations.
Manually Changing Server Collation
If reinstalling the SQL server is not an option, please refer to this Microsoft article explaining how to change the server Collation.