I created a report with SQL Server Business Intelligence Development Studio and uploaded it to a sharepoint 2010 foundation document library.
It works greate if someone with Sharepoint Full Control premission tries to open it.
But, it does not work if anyone else EVEN domain admins try to open the report. It returns this error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
List 'Phonebook' does not exist at site with URL 'http://servername/subsitename'. (rsSPDataProviderError)