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
>

Report Services: The server commited a protocol violation

Can anyone help with this problem?

I have a green light on my Report Services Confuration, and can configure the server within sharepoint integrated mode. I have also assign the appropriate permission for aspnet etc..etc.

From within Business Intelligent studio when I tried to publish my reports I get the below error:

The server commited a protocol violation

Here is a copy of the report server services log file.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__main_06_21_2007_10_47_38.log</Path>
<SystemName>DMTXDW01VM2</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!21/06/2007-10:47:46:: i INFO: Total Physical memory: 1073094656
ReportingServicesService!servicecontroller!4!21/06/2007-10:47:47:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'

Urgent help required!

Have you tried adding this to the web.config file?

<system.net>

<settings>

<httpWebRequest useUnsafeHeaderParsing="true" />

...

|||

Hi Tau Liang,

Many thanks for the help, but unfortunatly it did not help! Is the above to go into the Report Manager or Report Services web configuration file or other?

Randine