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

sql server reporting services

group:

Impersonation Account Permissions


Impersonation Account Permissions Dan Shookowsky
6/12/2006 11:27:01 AM
sql server reporting services: I'm attempting to call the Reporting Services Web Service from within my
application. I've set up anonymous access and set identity
impersonate="true" and supplied username and password attributes. If I set
the identity to the local administrator, I can call the web services and
render reports. If I set the identity to my least-privileged account created
for this purpose, the application fails with the following error.

Could not load file or assembly 'Microsoft.ReportingServices.Interfaces' or
one of its dependencies. Access is denied.


=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = Microsoft.ReportingServices.Interfaces
(Partial)
LOG: Appbase = file:///C:/Projects/ReportPipe/ReportPipe/
LOG: Initial PrivatePath = C:\Projects\ReportPipe\ReportPipe\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file:
C:\Projects\ReportPipe\ReportPipe\web.config
LOG: Using host configuration file:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom,
partial, or location-based assembly bind).
LOG: Attempting download of new URL
file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET
Files/reportpipe/ec668eaa/7af1073c/Microsoft.ReportingServices.Interfaces.DLL.
LOG: Attempting download of new URL
file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET
Files/reportpipe/ec668eaa/7af1073c/Microsoft.ReportingServices.Interfaces/Microsoft.ReportingServices.Interfaces.DLL.
LOG: Attempting download of new URL
file:///C:/Projects/ReportPipe/ReportPipe/bin/Microsoft.ReportingServices.Interfaces.DLL.
LOG: Using application configuration file:
C:\Projects\ReportPipe\ReportPipe\web.config
LOG: Using host configuration file:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: Microsoft.ReportingServices.Interfaces,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing
terminated.


I've tried to diagnose the problem using the security event log and FileMon,
but I've had no luck. What permissions do I need to assign to my
RE: Impersonation Account Permissions Dan Shookowsky
6/12/2006 1:24:02 PM
More information: I published the site and precompiled it. This gave me a
better error message indicating that the use required write access to the
AddThis Social Bookmark Button