After migration of Application server to another server Synchronization/Evaluation and CER jobs take a longer than expected time to store results and do not finish.
SQL Server Agent log related to the job includes the following message:
"Could not obtain information about Windows NT group/user 'Domin_name\Domin_login, error code 0x6e"
Control compliance suite 11.5.2 with SCU 2017-3 installed.
During migration DB was moved with a sysadmin account other than SA.
As a result SA lost authorization on CSM_Reports and CSM_DB after migration.
SQL Server internally requires SA to be authorized for CCS databases. Grant this SA authorization with the following statements to resolve the issue:
ALTER AUTHORIZATION ON DATABASE:: [CSM_Reports] TO [SA]
ALTER AUTHORIZATION ON DATABASE:: [CSM_DB] TO [SA]