My IT Experiences - Microsoft 365, SharePoint & Azure

We were getting this strange error while viewing our reports in SharePoint that was deployed using BIDS 2005: An error has occurred during report processing. Cannot impersonate user for data source 'datasource' Logon failed I tried many things but nothing worked. I did some research and found many blog posts which suggested me to reapply the password on the datasource file specified in the error message and save it again. That didn't work for me. I saw some check boxes in the data source file that read "Use as Windows Credentials" and "Set Execution Context to this report" and I didn't know what they meant. I unchecked those in my data source and then when the refreshed the page the report started displaying.

While clicking on "Audit Log Reports" under Site Collection Administration, I MOSS threw this error: The specified web does not contain a reporting metadata list There was no other information on this error. I activated the Reporting feature using force parameter and it solved the problem. This is the command: stsadm -o activatefeature -name Reporting -url http://[server]/[sitecollection]/ -force I do not know what caused this error, this site was not migrated from previous version of SharePoint, this happened in our root site collection. Regards, Manoj