Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : SQL Reporting Services - File Access Permissions Problem


epopo NO[at]SPAM attbi.com
7/21/2004 5:16:54 PM
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,

sray NO[at]SPAM hitachiconsulting.com
7/22/2004 7:28:58 AM
What your server OS? If Windows 2003, I'd suspect you're connecting
out to the UNC as MyMachine\NETWORK SERVICE

[quoted text, click to view]
Bryan Keller [MSFT]
7/22/2004 6:48:14 PM
Have you implemented IDbConnectionExtension? Also, be aware that
impersonation only takes place in the call to Open. There is some code you
can write to get around that. But try debugging your extension on the server
and see under what user context the call to the UNC file share is made.

--
Bryan Keller
Developer Documentation
SQL Server Reporting Services

A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.


[quoted text, click to view]

AddThis Social Bookmark Button