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:
2005 http://www.microsoft.com/download/en/details.aspx?id=8961
2008 http://www.microsoft.com/download/en/details.aspx?id=7593
2008 R2 http://www.microsoft.com/download/en/details.aspx?id=22985
- 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:
http://msdn.microsoft.com/en-us/library/aa337562.aspx
- 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).
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center