- Veeam Support Knowledge Base
- Issue With Data Warehouse Instance Collation
Issue With Data Warehouse Instance Collation
| KB ID: | 1465 |
| Product: | Veeam Management Pack | 5.7 | 6.0 | 6.5 | 7.0 | 8.0 | 9.0 | 9a | 13 |
| Published: | 2011-12-29 |
| Last Modified: | 2024-01-18 |
Cheers for trusting us with the spot in your mailbox!
Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest
Oops! Something went wrong.
Please, try again later.
Challenge
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.
Cause
Solution
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
More Information
If this KB article did not resolve your issue or you need further assistance with Veeam software, please create a Veeam Support Case.
To submit feedback regarding this article, please click this link: Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.