Read Reporting Services Catalog

[itg-assistant]

Ewan Walker asked 2018-02-27 11:35:50 UTC

I am trying to read the reporting Services catalogue on our server using

ReportingService2010 rs = new ReportingService2010();
rs.UseDefaultCredentials = true;
// Return the list of items in My Reports
CatalogItem[] items = rs.ListChildren(strFolder, false);
foreach (CatalogItem ci in items)

However the folder security is ignored as the whole catalog is read out which suggests the credentials of the pool account on the server are being passed instead of the client credentials.

Reports however run using the client credentials.

Does anyone know how to read the Report Server catalog using the client credentials (Windows Security) without having to pass Domain Username Password?

Thanks for your help

Ewan

[itg-assistant]

Ewan Walker answered 2018-02-28 15:24:12 UTC

Ok fixed it

You need to obtain the windows identity using

private Windows Identity WI = ApplicationBase.UserIdentity;

Then any calls to the ReportingService need to be made by impersonating the windows identity eg

using (WI.Impersonate())
{
LoadReports(trvReports.Nodes, "/");
}

Where LoadReports populates a tree view using the Report Server catalog according to the user permissions

HTH

Ewan