SSRS report builder - Failed to preview report

exception reporting-services reportbuilder
user1666952 picture user1666952 · Feb 27, 2014 · Viewed 9.6k times · Source

One of the user is trying to run a report through SSRS report builder from his computer. The same report would work through the SSRS reports website. But when he runs from his computer it fails. On the Report builder - test connections on Data source succeeds.

It errors out with "microsoft.reportingservices.diagnostics.utilities.accessdeniedException". Here is a screenshot. The results Google produced did not help.

http://screencast.com/t/nlxsprwQBefw

Answer

Scott R. Frost picture Scott R. Frost · Dec 15, 2017

Sorry to necro-post, but I had the same issue and @djangojazz's answer is almost correct, there are actually 3 steps:

  1. Log in to https://servername/reports as an administrator
  2. Click the gear in the top right > site settings > security tab. Add the user as a "System User"
  3. Click browse, and at the root level click "Manage folder", add the user to all roles.

After doing these steps on SQL Standard 2016 (version 13.0.4422.0) / Report Builder 3 (version 14.0.609.142), the user was then able to preview reports without having to give them full server admin rights / etc.

Related questions

How can I safely create a nested directory?

What is the most elegant way to check if the directory a file is going to be written to exists, and if not, create the directory using Python? Here is what I tried: import os file_path = "/my/directory/filename.…

Read More
Manually raising (throwing) an exception in Python

How can I raise an exception in Python so that it can later be caught via an except block?

Read More
How do you assert that a certain exception is thrown in JUnit 4 tests?

How can I use JUnit4 idiomatically to test that some code throws an exception? While I can certainly do something like this: @Test public void testFooThrowsIndexOutOfBoundsException() { boolean thrown = false; try { foo.doStuff(); } catch (IndexOutOfBoundsException e) { thrown = true; } assertTrue(thrown); } I …

Read More