RS in an Application Service Provider solution?

Hi,
We are thinking about using reporting services in an asp (application
service provider) solution and I have 4 questions regarding this:
- How can I authenticate the users before they access the reporting services
server? I don't want to expose my SQLServer and I want a mechanism that make
sure the user is a valid user before he/she gets to my SQLServer. Is it
possible (and a good solution) for me to let all traffic to my reporting
server go via my asp server which in turn does the authentication and then
redirects all the traffic to the reporting server?
- How can I prevent my users to see ALL reports on the reporting server. I
only want to display the reports that belong to the current user.
- How can I prevent my users to see the data of other users when he/she has
designed a report in report builder? Can I set a parameter for the datamodel
like a UserID?
- Is it possible to execute the Report Builder via an asp solution?
- Anyone who has experience of reporting services in an asp solution? Or
anyone who knows any good materials out there on this subject?
Kind regards
ThomasHi Thomas,
Welcome to use MSDN Managed Newsgroup!
>> - How can I authenticate the users before they access the reporting
services
>> server? I don't want to expose my SQLServer and I want a mechanism that
make
>> sure the user is a valid user before he/she gets to my SQLServer. Is it
>> possible (and a good solution) for me to let all traffic to my reporting
>> server go via my asp server which in turn does the authentication and
then
>> redirects all the traffic to the reporting server?
Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp?frame=true
>> - How can I prevent my users to see ALL reports on the reporting server.
I
>> only want to display the reports that belong to the current user.
You may specify differents role for different users to do this. For more
detailed information, check the article below
Reporting Services Security Model
(ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_3hia.htm)
Using Role-Based Security
(ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_8kqb.htm)
Understanding Role-Based Security
(ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_488h.htm)
>> - How can I prevent my users to see the data of other users when he/she
has
>> designed a report in report builder? Can I set a parameter for the
datamodel
>> like a UserID?
No, I am afraid you cannot.
>> - Is it possible to execute the Report Builder via an asp solution?
ASP or ASP.NET?
How do you want to interate the Report Builder with your asp solution?
You might have to access the report builder with the link directly
http://<localhost>/reportserver/reportbuilder/reportbuilder.application
where <localhost> is the name of the computer that is running Report
Server.
(make sure the Enable Report Design Client Button is set to True in the
ReportManager\RSWebApplication.config file by default)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.