I have been trying to use a custom XML data extension for SQL
Reporting Services. The extension works fine when in the Visual Studio
IDE, taking the "Connection String" (which is basically a directory
path to the XML document used for the report) as both file system
path and UNC path.
However, when I build and deploy the reports I am unable to "see" the
XML files. Both throughthe Reports Manager interface and through an
IFrame in my app I get the error that the "path doesn't exist" (canned
error from extension thrown because it can't access the UNC or file
path). Apparently the permissions are not set correctly to allow the
application to access the share that holds the XML file.
I have tried allowing read and full access via sharing and NTFS for
each of the following users
to no avail:
Everyone
MyMachine\ASPNET
Guest Account
Internet Guest Account
SYSTEM
I've searched high and low for an answer - it seems that the main
issue is that the aspnet worker process doesn't have access to the UNC
share through the Report Server web service. I have tried using
impersonation (using <identity impersonate="true"
userName="MyDomain\Me" password="pass"/> in the web.config file for
the Report Server app), but I get the same result.
Do you have any idea how to solve this issue? Any insight or hunches
would be greatly appreciated!
Thanks,