|
|
 
0 |
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 ".
Reason:
KB958979 - SQL collation "SQL_Latin1_General_CP1_CI_AS" needs to be designated for installing OpsMgr DB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;958979
Also in currently available requirements for OpsMgr 2007 R2 there are notice:
notice http://technet.microsoft.com/en-us/library/bb309428.aspx:
| 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.