Mysterious errors with authentication and Reporting Services

Mysterious errors with authentication and Reporting Services

Old forum URL: forums.lhotka.net/forums/t/3912.aspx


bgilbert posted on Monday, November 19, 2007

I'm trying to embed a ReportingServices server report in a Winforms ReportViewer control. This is a simple matter and works well when run in a small test application. However, for some reason, when run within an app that uses the authentication model from Chapter 5, it fails. The exception I get is:

System.TypeLoadException: Failed to load the proxy script runtime environment from the Microsoft.JScript assembly.

The inner exception is:
{"That assembly does not allow partially trusted callers."}

I have the application set to full trust and I'm not trying to call any assemblies from the report.

Try Googling the outer exception, and it looks like I'm the first person in history to get it. It's very clear that with authentication it fails and without it doesn't. I'm not very well versed in the ins and outs of authentication, so this is very frustrating and difficult to debug.

I should mention that I'm running XP locally, connecting to SQL Server 2005 on a 2003 server across a Novell network.

Any help would be greatly appreciated.

RockfordLhotka replied on Tuesday, November 20, 2007

Is it possible that your .NET assembly(ies) are being loaded from a network shared drive? Or a URL?

Either way, they'd be running in a partial trust environment by default, because they'd be coming from the Intranet or Internet zones.

bgilbert replied on Tuesday, November 20, 2007

Rocky,

Thanks for your reply.

No. The whole app is currently being run entirely from my local drive and it's set to full trust. The reportViewer control has methods to pass credentials to the server, but these seem to be very buggy. I've had to give up on this and just embed the reports in a web browser control. I'll try it again in VS2008 soon.


Copyright (c) Marimer LLC