How are you doing your authentication? There might be a problem with double
hops between your servers. That could be solved by using Kerberos between
these two servers.
Maybe this blog post will give you some clues:
Find an PublicKeyBlob from an assembly
http://geekswithblogs.net/tariq/archive/2006/10/10/93626.aspx Interesting bit is:
<em>
A colleague of mine had a problem today where she connected to RSWebParts on
MOSS 2007 and SharePoint gave her a security exception.
The solution was to make an exception for the RSWebparts assembly in
WSS_MinimalTrust.config.
</em>
Might give you something to work on?
Kaisa M. Lindahl Lervik
[quoted text, click to view] "Anco" <Anco@discussions.microsoft.com> wrote in message
news:30D9396C-0F2C-49CD-AE71-276B02B5AC1B@microsoft.com...
> This question is also posted in: microsoft.public.sharepoint.portalserver
> Since I did not get any replies until now I hope you guys can help me out.
>
> I have used the Reporting Services Webparts a couple of times in
> combination
> with SPS 2003 and SQL 2000/2005. Now we are running a pilot with SQL 2005
> and
> MOSS 2007. Problem is that the report explorer and the report viewer
> webpart
> do not show any reports.
>
> On the SQL 2005 server we installed the report server. This report server
> is
> up and running and the reports are available through the report manager.
>
> I installed the rswebparts.cab from the SQL 2005 server on the MOSS 2007
> server. I have inserted the webparts on a webpart page. This is how I
> configured the report explorer webpart:
>
> - The Report Manager URL: http://sql01/reports
> - Start path: dashboard
>
> I experimented with all kind of start paths like \dashboard\ or just \ or
> leaving it empty. But nothing seems to work. Could this be a MOSS specifi
> problem?
>
> These are my questions:
> 1) Does any one have experience using the RS webparts succesfully on MOSS
> 2007 or WSS v3?
> 2) Does any one have tips regarding MOSS 2007 and the RS webparts?
>
> Thanks in advance for your reaction.
>
> Anco
