I have created a Shared Data source in my Report Manager, granted my network account all the permissions to the connection. I build my report in Report Builder 2.0 (I have access to the necessary tables and views etc). I save my report to the report server.
I can run the report through Report Manager, however, I can't run the report through Report Builder 2.0. I get the error:
The permissions granted to user 'domain\myusername' are insufficient for performing this operation. (rsAccessDenied)
The odd thing is, if I create a report with an embedded data source, I can run it through Report Builder 2.0 until I save it to the server. Then I can only run it on the server (same as the Shared Data source), and not through Report Builder 2.0
Anyone have any ideas?
View Complete Post