SCOM 2007 R2,Cannot resolve the collation conflict

  • Article

Environment:

  1. SQL Server 2008 SP2
  2. Operations Manager 2007 R2.

Symptom:
=======
If a SQL Collation besides"SQL_Latin1_General_CP1_CI_AS" is specified when installing SQL OpsMgr will have  to be reinstalled as you will get errors after installing the product similar to the following:
Cannot resolve the collation conflict between "SQL collation "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

Workaround:
===========
When installing SQL server be sure to select SQL collation SQL_Latin1_General_CP1_CI_AS. If OpsMgr has already been installed you will have to reinstall SQL and OpsMgr to change the SQL collation.