Veeam Service Provider Console fails to connect to restored VSPC database due to collation conflict

Challenge When attempting to connect Veeam Service Provider Console to an existing VSPC database the following error occurs: Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict between "" and "" in add...

Issue With Data Warehouse Instance Collation

Challenge The following error message is displayed while generating reports: Cannot resolve the collation conflict between "SQL collation "SQLLatin1GeneralCP1CIAS" and "YourSQLCollationName" in the equal to operation. Cause A non-default SQL Collation is in use that is not supported by OpsMgr,...