I'm trying to render a report with the reporting services visualizer using a local report.
The report (rdl file) is as simple as can be, uses no parameters and works fine in visual studio.
The data source is left blank. I'm using module version 04.05.02 and SQL Server 2000.

Previously, I had to add an http handler and change the trust level to "High" in web.config to even get this far.

What I get at this point is either a blank module with no results or the following error:

* Request failed.

An error has occurred.
DotNetNuke.Services.Exceptions.ModuleLoadException: Request failed. ---> System.Security.SecurityException: Request failed. at Microsoft.Reporting.LocalService.set_Snapshot(ReportSnapshotBase value) at Microsoft.Reporting.LocalService.ResetExecution(Boolean recompile) at Microsoft.Reporting.WebForms.LocalReport.Refresh() at Microsoft.Reporting.WebForms.LocalReport.set_ReportPath(String value) at DotNetNuke.Modules.Reports.Visualizers.ReportingServices.Visualizer.DataBind() at DotNetNuke.Modules.Reports.Visualizers.ReportingServices.Visualizer.Page_Load(Object sender, EventArgs e) The action that failed was: Demand The type of the first permission that failed was: System.Security.PermissionSet The Zone of the assembly that failed was: MyComputer --- End of inner exception stack trace ---