A requirement for installation for System Center Orchestrator 2012 Beta is to have the right collation in SQL server.
As SCOM, SCO also needs the SQL_Latin1_General_CP1_CI_AS for its databases.
We where faced with an error in the Send Email Activity, caused by wrong collation.
As Microsoft told us, there is a bug submitted to check for right collation at installation time.
We actually force SQL_Latin1_General_CP1_CI_AS as we write our schema entries (as does SCOM) but having the alternate collation would have some impact in terms of temp table usage and such.
I have submitted a bug previously to include a prerequisite check requiring the SQL Server to be installed using SQL_Latin1_General_CP1_CI_AS so I will check on that bug to make sure it is in fact being included in RC/RTM.
COMMENTS