Hi there,
We had a similar need, where we had the need for Internet Reporting.
We implemented the custom authentication using Sql Server, we had
client facing Reports and we used Forms Authentication with sql server as our
auth. source. I used the sample code from Teo Lachev's book. Here is the
url for it.
http://www.manning.com/books/lachev/source It was very helpful and Teo was very kind to answer some great questions,
HTH,
Rakesh
[quoted text, click to view] "Summer" wrote:
> Hi,
>
> Our current situation is that we have exsting web application based on form
> authentication and most user has no windows account in our domain.
>
> And we start to use RS(SQL Server Reporting Service) and because RS running
> in its thread and seperate from our ASP.NET application and the RS
> authentication method is windows based. So, we need a solution to integrate
> them!
>
> And basically, What we want is that after users log in the ASP.NET
> application(form authentication), they can access the report base on their
> roles. And thr report application itself should be safe as well.
>
> We have tried the following ...
>
> Solution A: configure RS as anonymous access, and we can use url access to RS.
> Problem: No Security. Evryone can access the report.
>
> Solution B: create another account and use this account to call the web
> service proxy method to access RS.
> Problem: The RS access account must be saved in text somewhere, and call RS
> through web service proxy will decrease some function of url access such as
> toolbar etc.
>
> Solution C: use impersonation(specify one) in ASP.NET application and use
> the default credentials to call web service proxy method.
> Problem: The problem is same as B, and will cause extra cost for
> impersonation.
>
> I hope We can URL access RS because it is more powerful for web interface.
>
> Any ideal will be highly appreciated!
>
