Last post Jan 06, 2011 01:53 PM by prawinsreeram
Jan 03, 2011 07:16 AM|prawinsreeram|LINK
We have a requirement of using SSRS for rendering the reports using ReportViewer control. We are aware of the fact that SSRS requires Windows Authentication, but my requirement is to provide access to all the users stored in a database table who provide
valid credentials to access the SSRS report via web page and report viewer cotrol.
We are following the below steps.
1) Create a dummy windows level user say "dummy".
2) Provide "Browser" permissions to the "dummy" user.
3) Set Impersonation = true for the "dummy" user in the web.config file of the custom website that uses the ReportViewer control.
4) Follow all the required steps to configure the reportviewer control for accessign the SSRS report
After following all the above steps we are successfully able to access the SSRS report on the internet facing website without any Windows authentication popup.
Is this approach recommended? Please suggest..
P.S. We dont want to implement a Custom extension for implementing forms authentication.
SSRS anonymous access
usage of SSRS reports in cusom asp.net web application
Jan 06, 2011 01:53 PM|prawinsreeram|LINK
Below is my requirement.
1) Create a SSRS report using SSRS 2008 BIDS
2) There are couple of ways that could be used for displaying the SSRS reports in any of the web applications. My applicaiton is an ASP.NET application. Microsoft provide a special control named ReportViewer for rendering the SSRS reports. So, I have a Website
(ASP.NET) and a Webpage (.aspx page) and i want to display the SSRS report created in the Step 1 to be displayed in the Web page.
When we try to display a SSRS report in ReportViewer control (in the .aspx page) automatically the browser will prompt for username and password and we need to provide the windows AD user details to view the detail. This is the default behavior.
As We already have login page in our ASP.NET website and the users of our website are NOT Windows AD users,
By following the above 3 steps the browser will not prompt for credentials.
I just wanted to know whether this is recomended approach or not...