Last post Aug 24, 2011 05:00 PM by AceCorban
Aug 24, 2011 02:37 PM|MyronCope|LINK
using report builder 2.0
My setup is:
I have a report on my reportServer.
I need to access a folder on another server (we will call it "serverA" that has access rights set to "Everyone" so access and permissions is not an issue.
I'm not able to access the the folder on the other server. Since reporting services is run through IIS do I need to do something like create a virtual folder so I can access serverA?
Aug 24, 2011 02:46 PM|AceCorban|LINK
You'll need to use impersonation to establish the running .NET processes as a user on the domain. Then, set up a share on that domain that contains the file you are looking to access and grants read access to the impersonated user account. This, of course,
assumes that both servers are under the same domain. If not, I'm not sure this could be done without some form of a webservice running on the other end.
This is the article I've used in the past to use impersonation:
I've even written a "NetworkFile" class that functions just like "File" in many ways, though I don't have it on this computer at the moment.
Aug 24, 2011 03:15 PM|MyronCope|LINK
thanks for the feedback.
I am actually not using asp.net for this. I have a report on the report server that is calling an assembly that loops through folders on another server. Whenever i try to to this I am getting an error so it appears that my report cannot access the folders
on a different server (on a server that is not the reporting server).
I don't think I can or want to do whats in the link but looking for someway I can access the folders that I need to access. When I try to add a virtual directory I cannot get that to work either and I tried mapping the network drive and then passing that
to the code that loops through folders on a directory, I'm really stumped here...
Aug 24, 2011 05:00 PM|AceCorban|LINK
Yeah, you'll be limited to whatever the assembly is doing. Does the assembly accept any inputs or parameters? What's the error message?