Query execution failed for data set

[TheBig1980s]

Hello:

Years ago, I composed SQL reports for a client and placed them on a tab in Business Portal 4.0 (SharePoint). They all worked fine.

The reports pull from views that contain simple select statements with "UNION ALL" clauses delineating the data for each of the three company databases.

Recently, we consolidated this client's data into one company. So, I went into the first report’s view and modified it to only pull from that one company database.

When I run the report in SQL Reporting Services itself, it runs fine. No issues.

When I go to Business Portal, I get a page with the errors below.

Any ideas?

Thanks! John

• An error has occurred during report processing. (rsProcessingAborted)
o Query execution failed for data set 'Company'. (rsErrorExecutingCommand)
 For more information about this error navigate to the report server on the local server machine, or enable remote errors

 

[TheBig1980s]

UPDATE: Disregard this posting. There was a SharePoint trusted account in SQL that needed to have permissions to the new database. Once I got the permissions set to this new database, the report worked. I tried to delete this posting, but I don't see a way of doing so. Thanks, for the attention, just the same!