We were running CRM 3.0 with all reports working perfectly for all users. After an inplace upgrade to CRM 4.0 with the latest Rollup Updates, most reports no longer work. They work for me as a domain admin, but not for the other users. As I test I changed one users roll to a Sys Admin in CRM, but I did not see a change. I've looked at the SSRS side and all the permissions look okay. The exact error users get when they run the report is:
An error has occurred during the report processing: Query execution failed for data set 'DSNeglectedAccouts'. For more information about this error navigate to the report server on the local server machine, or enable remote errors.
Notice that "Accouts" is missing the "n". Not sure why, thought that is odd.
Any ideas on this? Since the report works fine for me, I don't feel like its an issue with the report itself.