SSRS2008 in SharePoint mode, anonymous access and PerformancePoint

Question

Hi,

I have SSRS in sharepoint integrated mode (sharepoint 2010, ssrs 2008R2)

Currently we must allows anonymous access to the root web site, so the users can see the welcome page first and they have to click a link and go under the secured sites hosted on the web server.

Under the secured section, the user can SSRS reports and PPS dahsboards etc... everything works fine and is secured.

but... I try integrated some SSRS reports into my PPS dashboards, and here the problems starts...

But because the anonymous access is on, PPS is not able to validate the report I want to use. there is this error:

Reporting Services does not support anonymous user from a SharePoint site.

Also ReportBuilder is not able to navigates the sharepoint folders, so I'm not able to save a report correctly from reportbuilder.

All the SSRS accesses must be secured, no anonymous access authorized to the reports etc...

So Is there any way or config to change to remove the anonymous authorization when accessing SSRS even when sharepoint is setup for anonymous accesses.

I push to change the architecture and separates the anonymous site from the secured content, but today I have to live with this mistake in the architecture.

So thanks for your help.

Answer 1

Hi Willgart1,

Based on the current information, I suggest that you open the SharePoint 2010 Central Administration, and configure the Reporting Services Integration to use Trusted Account authentication. You can specify a domain user account with minimal permissions to performing the operations.

If it doesn’t work, please try the following suggestion:

1. Select the Remember my password option when you provide your user credentials.
2. Configure the environment so that the user does not provide credentials. For example, in an intranet environment you might configure the SharePoint server to belong to a Workgroup and then create user accounts on the local computer.

For more information, please see the Tip in the following document:
How to: Configure Report Builder Access

Regards,
Mike Yin

If you have any feedback on our support, please click here

---

Mike Yin
TechNet Community Support