|Product:||SQL Server Notification Services|
|Message:||There is a collation mismatch between the main instance database and the application database.|
|This error maps to SQL Server error 446, which indicates that the specified operation was given objects with mismatched collations.
The event log entry for this error includes the description of the actual error that caused it, which looks similar to the following:
Cannot resolve collation conflict for <operation_name> operation.</operation_name>
|Determine the operation that failed from the event log entry and make sure that the arguments to the specified operation have matching collations. For example, if you have two columns in the same table with Greek and Latin collations respectively, a WHERE clause such as the following will cause this error:
WHERE GreekCol = LatinCol
The resulting error will have the following additional description:
Cannot resolve collation conflict for equal to operation.
The problem noted in this error must be resolved for the system to function properly.