System Center, Automation, Powershell and other Thoughts

SQL collation Requirement in System Center Orchestrator 2012 beta

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.

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.