During the online restore when a report is being generated the error message appears
"The Execute permission was denied on the object 'sp_GetReportsHeader', database 'Recoverymanager-Reporting-SERVERNAME', schema, 'dbo'"
The account performing the restore doesn't have permissionto the report database.
- Launch SQL Management Studio
Below are the links to download SQL Management Express:
- Connect to the SQL instance where the Report database resides with the account that has the correct permissions
- Provide the account that is having an issue with dbowner access to the database or create the new login for the Report database:
- You can also add additional users if using SQL Express by using the script provided in KB article 122000 (https://support.quest.com/recovery-manager-for-ad/kb/122000).