I am missing permissions somewhere for this user. They can access the SQL Reporting Services through web browser but when they try to run the report they get this error. I am not sure why they can’t.
When I download a SSRS report to work on in report builder running on my workstation, I cannot run the report. I get the same exact error message.
I have an alternate domain account (with higher privileges) that I must launch Report Builder using. To run as a different user, I right click the menu item, to get a popup menu like:
If there is a desktop shortcut, hold down the Shift key and right click the shortcut for:
I don’t get this error but i am an admin on the server. But I am not downloading the report. I am just right click in SSRS and running in Report builder.
My normal login is also an admin on the SQL server, but Running Report Builder on my workstation (with my normal login) won’t allow the report to run. Yet doing the same - but with my special login - works fine.
Where is Report Builder running from? You have it installed on your workstation? Or it launches from the web interface when browsing the report server?
With the report open, use the Data Source properties dialog to test the connection.
with my normal login, and running Report Builder on my workstation, I get:
with my special login I see “Connection created successfully”
1 Like
ok thanks…I have other user that can do it fine…hmmm…I missed something. But what you gave me helps alot.
I used to be able to run reports in report builder, from my normal login. But the DB guys did some thing on the SQL server that “broke” that. And what I call “broke”, thay would probably say “secured”. 
If I launch a web browser using my normal login, and try to view the SSRS portal, I get
Using my special login to launch a browser and the portal works fine.
I’d bet dollars to donuts that your user id isn’t in a group with access as defined on the SQL server. It doesn’t look loke it would be anything in SSRS Reporting Services Config Manager.
After looking at the Security settings of the DB for our reports (as specified in EAC), I see that my special user ID is actually the owner of that db.
1 Like
More than likely you may need to look at the security on the reports folder (through the SSRS web portal) and assign the relevant security to your user account, which may include you having to add your user account first. If that is the case it might be sensible to create an AD group (SSRS Editors for example) and assign yourself to that group and then add it to the SSRS security. As @ckrusen mentioned you may also need to have that group/user added to the security of the temporary reports database as well (which is the Catalog mentioned in the properties of the SharedReportDataSource.)
1 Like