Check the permissions of the account executing the report, you are more than likely using your credentials to execute the report, you may have to give the report account access to the database that the query is running against. Hope that helps, find out which account is running the report and logon to SQL STUDIO MANAGER and try to execute the query, you need to compare apples to apples.