Control Compliance Suite 11.5.2: Synchronization and Evaluation job does not complete after Data Base migration - SQL error code 0x6e

Products

• Control Compliance Suite Databases MS SQL SRVR
• Control Compliance Suite Windows

Issue/Introduction

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"

Environment

Control compliance suite 11.5.2 with SCU 2017-3 installed. 
 

Cause

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.

Resolution

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]