Client Management Suite

Does anyone know if it is possible to install Client Management Suite 7.1 to a database server running a different collation?

Implementation guide and support matrix indicate the following supported collations

• Latin1_General_BIN
• Latin1_General_BIN2
• Latin1_General_CI_AI
• Latin1_General_CI_AS
• Latin1_General_CS_AI
• Latin1_General_CS_AS
• Latin1_General_CP1_CI_AS

Customer has a SQL 2008 with collation French_CI_AS.
I was unable to install CMS 7.1 properly using this SQL-server. Database and tables were created but no records were created.
I also tried with changing the collation of the database to Latin1_General_CI_AS but this gave errors about conflicting collations French_CI_AS and Latin1_General_AS.

Currently running a local SQL Express on the CMS-server as a workaround.
It is impossible to change the collation of the production SQL-server because it contains to many databases.
Also it is not allowed to install a seperate instance of SQL-server due to risk of overloading the production SQL-server, doubtful but possible.

First, you are correct that you must use one of the collations listed.  Second, Altiris should have its own instance anyway.  If the node count will support it (small implementation), continue to use SQL on-box.  However, if this is a medium or large environment, you will need to install SQL off-box.  If the current SQL server is not an option due to collation and load, it looks like the path is clear: install on a new SQL server with the proper collation, dedicated to Altiris.