Report Viewer vs Report Server

Bonjour!
I deploy a report with Report viewer (Visual Studio 2005) on our web site
and it's working fine, I use the Integrated security. When I try to access
the same report but on the report server I have an authentication error but
with RV it's OK. This means it doesn't talk to the server the same way. Does
someone have hit that problem'
Regards, Joel:)On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> Bonjour!
> I deploy a report with Report viewer (Visual Studio 2005) on our web site
> and it's working fine, I use the Integrated security. When I try to access
> the same report but on the report server I have an authentication error but
> with RV it's OK. This means it doesn't talk to the server the same way. Does
> someone have hit that problem'
> Regards, Joel:)
Hello Joel, you may need to post more specifics on your authentication
setup.
I assume that by deploying "on our web site" you mean that you are
including a Reporting Services report as an object in a ASP.NET page
using the ReportViewer object. Authentication here is a local data
source connecting one-hop to a data source, pulling the data back to
the client and rendering on the client. When deploying to a Reporting
Server, the RS connects to the DS, pulls the data to the RS, renders
it to HTML, and sends the HTML to the client (you).
Check that you deployed to your Reporting Server using
"OverwriteDataSources" at least once, so the .ds files are actually
accessable. Then check the permissions on the Server, making sure
that the "user" that logs into the Reporting Services server has
permission to read from the data source.
Or you may have the "double hop" issue. You are at your desktop, NT
Authenticating to the Reporting Server, which should be sending your
authentication information to a SQL Server using NT Authentication.
This has failed at our company, and required a long process to get it
fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
or just search on "double hop" to find solutions.
-- Scott|||Thanks Scott, that's exactly what I'm doing, I will try the "Overwrite"
Regards, Joel :)
"Orne" wrote:
> On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> > Bonjour!
> > I deploy a report with Report viewer (Visual Studio 2005) on our web site
> > and it's working fine, I use the Integrated security. When I try to access
> > the same report but on the report server I have an authentication error but
> > with RV it's OK. This means it doesn't talk to the server the same way. Does
> > someone have hit that problem'
> >
> > Regards, Joel:)
> Hello Joel, you may need to post more specifics on your authentication
> setup.
> I assume that by deploying "on our web site" you mean that you are
> including a Reporting Services report as an object in a ASP.NET page
> using the ReportViewer object. Authentication here is a local data
> source connecting one-hop to a data source, pulling the data back to
> the client and rendering on the client. When deploying to a Reporting
> Server, the RS connects to the DS, pulls the data to the RS, renders
> it to HTML, and sends the HTML to the client (you).
> Check that you deployed to your Reporting Server using
> "OverwriteDataSources" at least once, so the .ds files are actually
> accessable. Then check the permissions on the Server, making sure
> that the "user" that logs into the Reporting Services server has
> permission to read from the data source.
> Or you may have the "double hop" issue. You are at your desktop, NT
> Authenticating to the Reporting Server, which should be sending your
> authentication information to a SQL Server using NT Authentication.
> This has failed at our company, and required a long process to get it
> fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
> or just search on "double hop" to find solutions.
> -- Scott
>