all groups > sql server reporting services > june 2006 >
You're in the

sql server reporting services

group:

Required Security for Report Viewer on Windows 2003 SP1 Web Server



Required Security for Report Viewer on Windows 2003 SP1 Web Server tfelber NO[at]SPAM gmail.com
6/13/2006 11:30:02 AM
sql server reporting services: 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'.
Re: Required Security for Report Viewer on Windows 2003 SP1 Web Server tfelber NO[at]SPAM gmail.com
6/13/2006 1:58:57 PM
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.


[quoted text, click to view]
Re: Required Security for Report Viewer on Windows 2003 SP1 Web Server tfelber NO[at]SPAM gmail.com
6/15/2006 6:02:32 AM
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.



[quoted text, click to view]
AddThis Social Bookmark Button