When I try to visualize few reports on I get error: “An error has occured during report processing. Query execution failed for data set ‘AvailabilityCahrtDataSet’. Cannot resolve the collation conflict between “SQL_Latin1_CP1_CI_AS” and “Latin1_General_CI_AI” in the equal operation “.
KB958979 – SQL collation “SQL_Latin1_General_CP1_CI_AS” needs to be designated for installing OpsMgr DB
Also in currently available requirements for OpsMgr 2007 R2 there are notice:
Operations Manager Operations database
· SQL Server 2005 Standard or SQL Server 2005 Enterprise Edition with Service Pack 1, Service Pack 2, or Service Pack 3, or SQL Server 2008 with Service Pack 1.
· SQL collation must be SQL_Latin1_General_CP1_CI_AS; no other collation configurations are supported
How to fix it: migrate DB to properly installed SQL Server.