Regresar
-
Título
Could not create/update database: Failed to update Agent Database Schema -
Descripción
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 -
Causa
SQL Server collation is set to something different than the default collation value: SQL_Latin1_General_CP1_CI_AS
-
Resolución
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. -
ID de defecto
549477