I have set up SSRS on my localhost, and used BIDS to create a couple of reports on them. They access data from the same SQL Server where the SSRS is deployed, and when I preview them they run fine. Then I deployed them to my localhost SSRS and accessed them via the ReportManager web interface, again they ran just fine. Finally I deployed them to my hosting provider's SSRS. Same deal; good data connectivity and it looks great in the ReportManager.
The first time I access them through the ReportManager on either system, it demands my username and password, which on my laptop is just my account logon and password. For my hosting provider it's my account logon for them.
My problem is when I try to display a report using the ReportViewer control in ASP.Net. Very often, when it tries to render I get a "Bad Logon" or "401: Unauthorized" instead of my report. After a lot of reading and pondering, I believe the problem is that I need to log on not to the SQL Server, but to the website (web service?) where my reports are exposed. Right now if I don't provide any credentials at all, I can get my local reports in the ReportViewer (usually). However, when I deploy the reports to a remote server, this doesn't work anymore.
After some research I created a class that implements IReportServerCredentials and tried using it to pass in the username and password, but this doesn't appear to work. And it was confusing me whether these credentials are supposed to be for the data source or for the web service.
If anyone could clue me in on how to get the ReportViewer to log in to the SSRS web service, I'd much appreciate it.
