How to authorize user to view report in SSRS 2005

See more:

SSRS

Hi All,

I have created an ASP.NET 2.0 web application and would like to use SSRS 2005 for reporting purposes.

The web application uses forms authentication and custom roles for authorization. I have created reports and deployed it to a our SQL Server 2005 box.

I have Used ReportViewer control and display reports using that. All processing will be done by SSRS

Currently it is set to Windows Integrated Authentication. Also the reporting service has my username with Browser role.

Not all users of my application will have Active Directory(AD) login. Also the application is on internet and I don't want to open up SSRS more than necessary. At the same time, I want it to be seamless for our users in that I don't want SSRS to prompt for username and password.

What is the best way to accomplish this? Should I create a dummy AD user and then use it to communicate between ASP.NET app and SSRS? Or if not that, what is the easiest way that achieves everything I need?
Thanks in advance.

regards,

Abhinav