RS report integrated with .Net web app

I am trying to integrate a Reporting Services report within a .Net web
application. The easiest way to do this is to create a frame from within the
web application and link to the Reporting Services report. That way it
appears to be part of the application. But how can it be setup so that the
user doesn't have to log in twice? Once for the web application and then
again after they click on the link that goes to the Reporting Servies report.
How can I turn off the login prompt that comes up when the user clicks on
the link to the RS report but still lock down Report Manager? Also, how can
the roles be shared that is used from within the web application and the
reporting services report?Hi,
If you haven't resolved this issue first implement and install the Custom
Authentication Forms Authentication Example:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
and then see the following:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformsauthenticationacrossapplications.asp
Its actually quite simple to setup once you have configured and set up the
Custom Authentication Forms Authentication Example.
Good luck,
Nick @. INDATA
"David" wrote:
> I am trying to integrate a Reporting Services report within a .Net web
> application. The easiest way to do this is to create a frame from within the
> web application and link to the Reporting Services report. That way it
> appears to be part of the application. But how can it be setup so that the
> user doesn't have to log in twice? Once for the web application and then
> again after they click on the link that goes to the Reporting Servies report.
> How can I turn off the login prompt that comes up when the user clicks on
> the link to the RS report but still lock down Report Manager? Also, how can
> the roles be shared that is used from within the web application and the
> reporting services report?|||Did you get this to work? I am trying to do the same thing.
"David" wrote:
> I am trying to integrate a Reporting Services report within a .Net web
> application. The easiest way to do this is to create a frame from within the
> web application and link to the Reporting Services report. That way it
> appears to be part of the application. But how can it be setup so that the
> user doesn't have to log in twice? Once for the web application and then
> again after they click on the link that goes to the Reporting Servies report.
> How can I turn off the login prompt that comes up when the user clicks on
> the link to the RS report but still lock down Report Manager? Also, how can
> the roles be shared that is used from within the web application and the
> reporting services report?|||This is most likely a double hop issue. Windows NT Challenge Response does
not support double hop (in that once passed to the IIS server, the same
credentials cannot be passed to a back-end server for authentication). Do do
this you need to be using Kerberos. As far as Active Directory and Kerberos,
other than knowing you can do this, I don't know any more than that.
Another option, is to have RS on the same server as your app. The database
can be on a different machine. This does mean that you need to have a
license for SQL Server wherever RS is installed.
The other option is to implement Forms based authentication (i.e. you
provide the user authentication). This is non-trivial but is the method that
is used by people using RS over the internet.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Katie" <Katie@.discussions.microsoft.com> wrote in message
news:6A87F447-C852-4668-9542-3C7A19571C6D@.microsoft.com...
> Did you get this to work? I am trying to do the same thing.
> "David" wrote:
>> I am trying to integrate a Reporting Services report within a .Net web
>> application. The easiest way to do this is to create a frame from within
>> the
>> web application and link to the Reporting Services report. That way it
>> appears to be part of the application. But how can it be setup so that
>> the
>> user doesn't have to log in twice? Once for the web application and then
>> again after they click on the link that goes to the Reporting Servies
>> report.
>> How can I turn off the login prompt that comes up when the user clicks
>> on
>> the link to the RS report but still lock down Report Manager? Also, how
>> can
>> the roles be shared that is used from within the web application and the
>> reporting services report?