What are the SQL Server database roles required to allow access to the CA database for the SQL Connect Data Source integration with Change Auditor?
Regardless of whether Windows or SQL Authentication is used, the user credentials you enter in the SQL Connect Data Source configuration for Change Auditor must have at least the "db_datareader" role assigned in the SQL Server hosting the target Change Auditor database.