How do I resolve issues that arise due to using an unsupported database collation?
Using the incorrect collation on a Japanese operating system will throw the following error:
This issue is due to the newer version of Microsoft SQL 2005 running on an non-English operating system using the machines locale as default collation setting, in this case Japanese_CI_AS.
You will not ba able to create new configuration automatically as the database has no tables created. As a workaround you need to create the database and DSN manually before the server configuration is created.
You may follow the steps below to resolve the error:
Author: Fong, SokNee