Configuring SQL Server Collation in EngageOne Content Author

Product Feature: Installation / Upgrade
Database: SQL

 

Issue

The following configuration error occurred in the EngageOne Content Author Configuration Manager:
Message: Cannot resolve the collation conflict between "Modern_Spanish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Cause

Configuring SQL Server Collation other than SQL_Latin1_General_CP1_CI_AS.

Resolution

UPDATED: December 10, 2019
Only the default SQL Server collation SQL_Latin1_General_CP1_CI_AS is supported in EngageOne Content Author. A new instance of SQL will need to be installed with the correct collation selected during the time of installation.