We are using Backup Exec 11d on a Windows 2003 server with SQL Express 2005 handling the database.
Until just recently we were able to run reports without any problem. In fact, we run a custom report every week on a schedule. Last week it ran; this week it doesn't. Nor do any of the built-in reports run.
When you try to run the report by right clicking the report itself you get this:
"Unable to run report. No further information available"
If you right click the report and choose "Edit' and then click on the "Preview" option you get:
"The report could not be generated. Database Access Denied"
And when trying to run report by right clicking the "Scheduled report" it fails with this error in the Job History:
"e0008385 - The report stored procedure reported an error."
I have verified that the user I am logged in as has access to the database.
I have also added another user, granted database access, and logged in as that user.
I am able to view all other information in the database by viewing the different tabs, so I am assuming that the data is there. I just can't get a report to run.
Any thoughts on what might be the problem?