Persistence Options for Results Services

Information about messages might need to be stored to ensure transactional consistency of long-running transactions. The persistency configuration defines where the data is stored. It is recommended to store it in the CM4D Site database, but another database can be configured if necessary. Additional persistency options will be available in future releases.

SQL

The CM4D installer sets SQL as the default configuration. Replace the empty persistence connection string with your CM4D Site database connection string.

"Persitence": {
“Name": "SQL",
"ConnectionString": "Data Source=SERVER;Initial Catalog=DATABASE;User ID=USER;
Password=PASSWORD; TrustServerCertificate=True;MultipleActiveResultSets = True"
}

The database connection string is configured in the appsettings.json file for each installed service.