SSRS/.Net – SSRS not working locally on server. ASP.Net’s ReportExecutionService or ReportViewer breaking with “HTTP 404” error while accessing SSRS URL
Hello all. In this post I’m picking up an interesting problem related to SSRS, which was a result of a small miss in SSRS configuration and can keep novice DBAs wondering for long, what has went wrong (Hey does it rhymed!!). As we know .Net Framework provides easy and extensive integration of technologies and SSRS is no exception to it. There are multiple ways in .Net through which SSRS reports can be directly used within the application like using “Report Viewer” component, which is simpler to implement and use. Other ways is using more complex (means needs more coding) is “Report Execution Service”. In both the cases the SSRS report server URL should be accessible to application. Problem Our DEV team was working on one such integration using the “Report Execution Service” method, so one of our DBAs installed and configured SSRS components and provided the respective URLs to the team to use after providing appropriate rights to folders. Team was successfully able to depl