SYMPTOM
The SL database upgrade process is unsuccessful. You review the dbbuild.log and see messages that resemble the following:
Database Name: <Database Name>
Error Code: 468
Error Text: Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
-or-
Error Code: -2146232060
Error Text: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_CI_AS" in the equal to operation.
CAUSE
This error will occur when the SQL server is not using the default character set and sort order.
RESOLUTION
Dynamics SL only supports the default sort order.
Note: Microsoft Dynamics SL supports only the default Character Set (Code Page 1252 for non-Unicode Data, Sort Order 52 and dictionary order, case insensitive) for SQL Server. Because instances of SQL Server can have only one Character Set and Sort Order, separate servers must be used if other applications require different settings.