Tuesday, November 20, 2012 3:15 PM
We needed your suggestions in one of the issues we are facing in our project.
- 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.
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.
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”
SQL Server 2008 R2
Wednesday, November 21, 2012 6:10 AMModerator
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:
If you have any questions, please feel free to ask.
TechNet Community Support
Thursday, November 29, 2012 5:11 PM
No Charlie, he means that Sharepoint session should ask credidentials only once as it clearly shows in his text
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.