I installed SSRS on my localhost and used BIDS to create a couple of reports about them. They access data from the same SQL Server on which SSRS is deployed, and when I look at it, they work fine. Then I deployed them to my local SSRS system and accessed them through the ReportManager web interface, and they just did a great job. Finally, I deployed them to my SSRS hosting provider. Same deal; good data connectivity and looks great in ReportManager.
The first time I access them through ReportManager on any system, it requires my username and password, which on my laptop is just my account and password. For my hosting provider, this is my account for them.
My problem is trying to display a report using the ReportViewer control in ASP.Net. Very often, when he tries to do, instead of my report I get "Bad Logon" or "401: Unauthorized". After many readings and thoughts, I believe that the problem is that I need to log in not to SQL Server, but to the website (web service?), Where my reports are displayed. Right now, if I don’t provide any credentials at all, I can get my local reports in ReportViewer (usually). However, when I deploy reports to a remote server, this no longer works.
After some research, I created a class that implements IReportServerCredentials and tried to use it to pass username and password, but this does not work. And I was confused if these credentials should be used for a data source or for a web service.
If anyone can understand me how to get ReportViewer to log in to the SSRS web service, I would really appreciate it.
source
share