SharePoint and SSRS: Login prompt coming up

Question

We needed your suggestions in one of the issues we are facing in our project.

Scenario:

• We have a SharePoint web application and which is deployed in Server 1 (S1) and SQL Server Reporting Services is also configured on the same server S1. SSRS is configured in Native mode.
• Reporting Server database is in Server 2 (S2) and we are deploying the reports to S1.
• We have created Performance Point Dashboards on which one of the web part is an SSRS Report.
• The PPS dashboards are then deployed on to a SharePoint site which is using FBA for login.
• The dashboard also has PPS Scorecards which connect to a Cube and they work just fine. The Cube is deployed in S2.

Problem:

                After successfully logging in to the SharePoint site on which the dashboard is deployed, the web part which has the SSRS Report again prompts  for login. However, once the user provides the login details successfully, the user is able to view the report.

Objective:

SharePoint should prompt for credential only once and same credential should be used for showing the SSRS report without asking again.

Reporting Service Configuration Details

                Report Server Service Account: Network Service

                Report Server Web Service URL: http://s1:80/ReportServer

                SQL database configuration: ReportServer DB (S2) and credential used is “SQL Server Account”

Software version:

                SharePoint 2010

                SQL Server 2008 R2

Answer 1

Hi,

From you description, you want SharePoint should prompt for credential again if user want to view report items, right? If in this case, why not set permissions for Report Server Items on a SharePoint Site? Custom security settings can be useful if you want to restrict access to a particular report. You can set permissions on report definition (.rdl), model (.smdl), and shared data source (.rsds) files. If user has the permission, then he can see the report item without authentication. For more information about how to set permission for Report Server items on a SharePoint site, please see:
http://msdn.microsoft.com/en-us/library/bb283150(v=sql.105).aspx

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

---

Charlie Liao

TechNet Community Support

Answer 2

Hello

No Charlie, he means that Sharepoint session should ask credidentials only once as it clearly shows in his text

"Objective:

SharePoint should prompt for credential only once and same credential should be used for showing the SSRS report without asking again."

I have same problem. Reports creating/opening ect. asks new login. That is NOT working properly.