- SQL Server 2008 SP2
- Operations Manager 2007 R2.
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.
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.