Error message appears on the Control Compliance Suite console or in the logs of CCS manager
When you connect to the reporting database in a user context that has insufficient rights on the reporting database, an error message Login failed for user <username> appears on the Control Compliance Suite console or in the logs of the CCS manager in a reporting role:
To correct this issue, you must do the following
Check if you can connect to the SQL Server from the Application Server and CCS manager using the same user context
Verify whether the user context used to connect to the reporting database (CSM_Reports) is having the role of db_owner. Else change the user context or add the user context to the role of db_owner in the reporting database.