SSRS authentication in a MVC application?

Question

I have a ASP.NET MVC project which connects to SSRS using `ReportingService2010` web service endpoints to retrieve and download reports. Connection works fine using `CredentialCache.DefaultCredentials` when developing locally with Visual Studio running with admin privileges When published to virtual directory or used with `NetworkCredential` with `domain\\username` it doesn't work as expected. I added the windows system user in SSRS as a system administrator. Current syntax which only works when running locally in Visual Studio with admin privileges. ReportingService2010 service = new ReportingService2010(); service.Credentials = CredentialCache.DefaultCredentials; CatalogItem[] items = service.ListChildren(reportsFolderPath, true); Is there a way to configure `domain\\username` password with `NetworkCredential` ReportingService2010 service = new ReportingService2010(); var credentials = new NetworkCredential("insharp", "abc123", "insharp-lenovo"); service.Credentials = credentials;

Answer 1

To resolve the issue with your ASP.NET MVC project connecting to SSRS using ReportingService2010 when not running locally, you'll need to configure the NetworkCredential correctly. It's important to ensure that the domain, username, and password are correctly set. Here's how you can modify your code:

ReportingService2010 service = new ReportingService2010();

service.Url = "http://YourReportingServer/ReportServer/ReportService2010.asmx";

var credentials = new NetworkCredential("username", "password", "domain");

service.Credentials = credentials;

CatalogItem[] items = service.ListChildren(reportsFolderPath, true);