SSRS Report Manager

0
votes

I am implementing an SSRS project but I have issues with the deployment phase.

My requirements

  1. Deploy the report to the reporting server
  2. Allow Users to access the reports from a custom web application.
  3. Users should access the reports with any browser
  4. I don't have a sharepoint/Domain authentication so I am using a custom web app

My Challenges

After deploying the reports to the report server, If I try to access the Report Manager Url from my client system I receive an prompt requesting for the Windows Login Credentials of my Reporting Server. I want disable this prompt.

Please I need your help. Thanks

2
visual-studioreporting-servicesreportmanager

2 Answers

0
votes

You need to edit the data source of that report (or of the shared data source if it uses one) and choose the option "Credentials stored securely in the report server", adding the credentials appropriate to the data source there.

The problem you're having is that the default data source authentication (as with SQL Server itself) is Windows integrated authentication, and that's why you're getting prompted for credentials from a browser connection.

See here for an overview on how to store credentials with the data source.

0
votes

In your web application's web.config add identity impersonate="true" and SSRS 2012 does not use IIS.