Always use a CAST AIP setup installation. For reproducing issues, flat installation is not recommended because the analysis/snapshot may fail. This can be due to files that are missing in the flat installation.
In the above query the original name of the users central database is sample_central
where site_id= <site_id>
Replace <new_CB_name> with the restored central database name (following the naming convention) and <site_id> with the siteID returned in the above query.
where site_id= 123456
Modify the META-INF\context.xml in your deployed tomcat area for the database server and the central database name
Add a user to access the ED dashboard with the role ROLE_ADMIN (unless the issue is related to specific roles, then you may need to do further configuration as per the issue that is being investigated): User authentication