Permissions to display a report in SharePoint Services (SSRS integrated mode)

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

needSleep — Wed, 17 Feb 2010 15:10:02 GMT

You can't believe how many hours I spent reading blogs, trying solutions and always with no result...

And then I came across this post...

Approve the data source...

And It works....

Thank you sooooo much!

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

BigGuy147 — Tue, 30 Mar 2010 14:52:46 GMT

Thanks. I have a similar problem with SSRS 2005 and WSS3.0 (not Moss). How do I "approve" the data source once it is deployed?

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

PortPortPort — Wed, 28 Jul 2010 21:15:30 GMT

Awesome! Totally awesome. Just like needSleep spent way to much time looking for the fix to this issues. Thanks a ton!

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

PortPortPort — Wed, 28 Jul 2010 21:15:30 GMT

Awesome! Totally awesome. Just like needSleep spent way to much time looking for the fix to this issues. Thanks a ton!

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

Larry K — Fri, 23 Dec 2011 15:17:59 GMT

Thank you so much for posting this...you've a life saver.

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

Brent K — Mon, 16 Jan 2012 19:51:45 GMT

You may also have this error if (1) you are using a shared data source and (2) the usr is not a site "member". If you only want to have users be "Viewers", then remove the shared data source and assign the data source within the report.

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

Marco Russo (SQLBI) — Mon, 16 Jan 2012 21:36:05 GMT

Thanks for the comment, Brent!

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

Emil Glownia — Tue, 31 Jan 2012 12:56:49 GMT

Thanks a lot that saved me a lot of time. They didn't make it very obvious.

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

Isa — Tue, 13 Nov 2012 10:26:12 GMT

I spent two days trying to understand why I had the problem. Cheers

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

Rudolf — Thu, 29 Nov 2012 12:59:27 GMT

Thanks MAN!

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

San — Fri, 21 Dec 2012 11:25:07 GMT

I have the same problem(SSRS -2008 & SP-2010) Where I need to approve, I don't see any option

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

MD — Thu, 17 Jan 2013 09:54:58 GMT

Thanks a lot for the post. I am using SP2010, so instead of approving, I just had to publish a major version for the same effect. Thanks again.

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

RD — Tue, 12 Mar 2013 17:22:33 GMT

Seems like a theme here - I spent a good 8 hours chasing this down -

re: Permissions to display a report in SharePoint Services (SSRS integrated mode)

Blaž Dakskobler — Tue, 16 Apr 2013 14:20:36 GMT

Actually, Brent K, as far as I've tested it, it is enough to have "View Only" permissions on the shared data source, and it works. No need to use a custom data source instead of the shared one.

Also, if you use a higher permission level than "View Only" (e.g. "Read"), then users can access and use that shared data source in Report Builder etc. Which may not be what you wanted to achieve security-wise.