Search code examples
c#reporting-servicesreportingservices-2005

About Reporting Server Permissions

I have an ASP.NET application that runs under Classic .NET AppPool.

I'm trying to render a report hosted in Reporting Services in another machine, with the correct address and everything. But I keep getting the following error, which I just can't solve:

Cannot create a connection to data source 'MYDATASOURCE'. (rsErrorOpeningConnection) ---> Microsoft.Reporting.WebForms.ReportServerException: Login failed for user 'NT AUTHORITY\IUSR'.

I won't post any code, I'm simply calling the .Render() method through Microsoft.Reporting.WebForms.

Could it be a configuration or some special permission I have to grant to my code?

Any Help?

Solution

  • Granting permission directly on the database to the user NT AUTHORITY\IUSR solved the problem. I'm not very sure about security issues doing this, but thats another question.

    Thanks.