Required Security for Report Viewer on Windows 2003 SP1 Web Server

[tfe...@gmail.com]

When trying to run a local report using the RS Report Viewer for VS
2005 we get the below exception when the User Account for the
Application Pool we are using is not in the Administrators Group of the
web server.

Does anybody have any suggestions as to what specific security is
needed to use the Report Viewer?

Could this be because we built the application as a "Web Project"
instead of a "Web Site"?

Microsoft.Reporting.WebForms.LocalProcessingException: An error
occurred during local report processing. --->
Microsoft.Reporting.DefinitionInvalidException: The definition of the
report 'Main Report' is invalid. --->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred while compiling expressions. Native
compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
could not be found'. --- End of inner exception stack trace --- at
AMR.AdvertiserClientList.RefreshReport() in C:\Documents and
Settings\god\My Documents\Visual Studio
2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 192 at
AMR.AdvertiserClientList.RUNREPORT_Click(Object sender, EventArgs e) in
C:\Documents and Settings\God\My Documents\Visual Studio
2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 50 ::
InnerException: Microsoft.Reporting.DefinitionInvalidException: The
definition of the report 'Main Report' is invalid. --->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred while compiling expressions. Native
compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
could not be found'.

[tfe...@gmail.com]

This error is also logged in the system event viewer, however granting
access NETMAN in the DCOM manager only keeps the errors from showing
and does not fix the problem. The CLSID refers to tthe Network
Connection Manager Class (under the NETMAN application).

The application-specific permission settings do not grant Local
Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user AMI\srvAcctAppAccessDEV SID
(S-1-5-21-2975352776-793034493-3225607600-10632). This security
permission can be modified using the Component Services administrative
tool.

[tfe...@gmail.com]

Finally figured it out.

The configurable identity that our application pool was using under
IIS 6.0 needed read/write access to the c:\Windows\Temp directory.
(Explains why we could get this to work when the account was part of
the Administrators or Power Users Group). I suppose this is to give it
temp space when rendering large reports.

Hopefully this helps somebody else out one day.

[joe]

thank-you :)
I added 'read' permission to C:\WINDOWS\Temp for the pool user and this error now disappears:

An error occurred during local report processing. The definition of the report 'Main Report' is invalid. An unexpected error occurred while compiling expressions. Native compiler return value: 措BC2001] file 'C:\WINDOWS\TEMP

reportviewer
asp.net 2.0
rdlc

From http://www.developmentnow.com/g/115_2006_6_0_0_772341/Required-Security-for-Report-Viewer-on-Windows-2003-SP1-Web-Server.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/