Issue rendering an RS hierarchy using ReportingService2005
All, I was tasked with building a front-end to Reporting Services. I've built it in ASP.NET/C# and works great with the exception of one major problem. I'm using a TreeView to display the RS hierarchy. The problem is that, when I populate the TreeView, only folder/report instances that have a user/group of Everyone with a Browser role are rendering. Folders/Reports that are assigned to specific users, do NOT display, when either the specific user or an Administrator is using the app. When I establish credentials, I issue the following command . . . rs.Credentials = System.Net.CredentialCache.DefaultCredentials; I've been stuck on this for a while, any help would be much appreciated! William A. Reiss
May 4th, 2012 1:26pm

Hi William, From your description, I suggest that you check the following factors: The ReportingService2005.SetPolicies Method.The roles except Browser do exist. You can use the ListRoles SOAP APIs to get the available roles.There is not another policy associated with the same users. For more information about ReportingService2005.SetPolicies Method and the sample, please see: ReportingService2005.SetPolicies MethodExample of using SSRS SOAP API Hope this helps. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2012 4:10am

Thanks, Mike. I'll take a look at the links you've provided and hopefully they'll shed some light on the issue. One thing that might also be the problem is that this is a Web app, and the RS server is on a different box than the Web server. William A. Reiss
May 8th, 2012 12:41pm

So far I haven't found the answer. Here's my problem in a nutshell . . . If I launch my web app that renders the RS tree from VS2010's test web environment, the web app displays all the folders correctly. However, if I run the same web app via IIS (from same test box), the web app only renders Public folders. So it looks like when running under the test web evironment, my credentials are produced from System.Net.CredentialCache.DefaultCredentials and ALL reports are rendered in the TreeView. If I run the same code directly under IIS, the app pool's credentials are produced from DefaultCredentials which only renders public folders in the TreeView. So the question is, how am I able to get the app running under IIS, to see the user's credentials, and not the app pool's? William A. Reiss
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2012 4:33pm

OK . . . here's the solution!!! After banging my head against the wall multiple times, I decided to install the web app directly on the RS server. The reasons were two fold. First off, I thought I was running into the triple hop security issue and wanted to take a layer out of the picture. Secondly, the app would reap performance gains. Well, that didn't help my security issue. Still seeing only Public RS folders. (Speed wise, it helped in magnitudes) Now here's the rub . . . I decided to try to add a line of code that HAS ALWAYS ERRED in my web.config. This is supposed to tell the web server to impersonate the windows user. Here's the line of code . . . <identity impersonate="true" /> This one line of code fixed the problem I had for weeks! The question I still have is . . . why was I getting a compilation error on all machines exept for the RS box when I added that line of code to the web.config previously. The why, is still a mystery to me, but at least I got passed the issue! William A. Reiss
May 17th, 2012 8:01pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics