Issue With Data Warehouse Instance Collation

The following error message is displayed while generating reports:

Cannot resolve the collation conflict between "SQL collation "SQL_Latin1_General_CP1_CI_AS" and "{Your_SQL_Collation_Name}" in the equal to operation.

To avoid this issue, make sure that the supported collation is specified for OpsMgr and Data Warehouse databases when installing OpsMgr. For existing installations it may be required to port/reinstall OpsMgr to use a supported SQL collation configuration.

For a list of collations supported by Ops Mgr, see:

• Ops Mgr 2012 SP1 system requirements at technet.microsoft.com/en-us/library/dn249696.aspx
• Ops Mgr 2012 R2 system requirements: technet.microsoft.com/en-us/library/jj656654.aspx