EN: Exchange 2010 MP Reports – fail on not properly designed OpsMgr installation

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 “.

 

clip_image002

clip_image004

 

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.

0 thoughts on “EN: Exchange 2010 MP Reports – fail on not properly designed OpsMgr installation

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.