Could not create/update database: Failed to update Agent Database Schema (4376073)

Could not create/update database: Failed to update Agent Database Schema

When trying to connect to a new or existing job database getting the error message:
Could not create/update database: Failed to update Agent Database Schema

SQL Server collation is set to something different than the default collation value: SQL_Latin1_General_CP1_CI_AS

 

To check Server collation value run this query:
SELECT SERVERPROPERTY('collation') AS ServerCollation;

If the result is different than SQL_Latin1_General_CP1_CI_AS use any of the following workaround:

Scenario 1: Existing job Database
Alter the collation of the existing Database you are trying to connect with Content Matrix using the query below:

ALTER DATABASE [DBName] COLLATE SQL_Latin1_General_CP1_CI_AS;

*Replace [DBName] with connected CM Database name.

Scenario 2: Creating a new job Database
Create a new database with the query below and then open Content Matrix and connect to this job database:

CREATE DATABASE [DBName] COLLATE SQL_Latin1_General_CP1_CI_AS;

*Replace [DBName] with Database name.

549477