LukasM
12 years agoLevel 3
Collation error - Enterprise Vault
Deployment scanner display this error
How do I change de collation lenguage?
From the Installation and Configuration guide: "The SQL installation must be case-insensitive, as case-sensitive SQL installations are not supported". If this is a new SQL server, reinstalling the instance with the correct collation would be the fastest solution. However, the recommendation is that the user's DB collation matches the Master DB collation.
Here is a Microsoft blog with some SQL queries to change the database collation, but this is something you need to review with your DBA since the steps involve in the process are complex:
http://blogs.msdn.com/b/ikovalenko/archive/2006/12/03/alter-database-alter-collation-forced.aspx