Recently doing a BPC install in a Network Load Balanced (NLB) environment and ran into an error when testing the Reporting Services on the second application server. When clicking on the Report Manager URL I would receive the error:
The report server installation is not initialized
It turns out I needed to go back to the first server and run Reporting Services Configuration Manager and select Scale Out Deployment, then join server two.
By using the ASP.NET ReportViewer control on a web page exposed to the internet, it is possible to display Reporting Services reports. The trick is in turning on Anonymous Access on the ReportServer Virtual Directory and creating the anonymous user as a Reporting Services user and granting that user permission to view the reports you want to share.
In the ReportViewer control configure the ReportView Tasks as follows:
- Choose Report:
- Report Server Url: the path to the ReportServer Virtual Directory
- Report Path: the path to the report beginning with ‘/’
On the web server hosting Reporting Services configure the ReportServer Virtual directory as follows:
- Turn on Anonymous Access
- Remember the Anonymous Access user
In Report Manager do the following:
- Configure the Anonymous Access user as a Reporting Services user
- Grant that user access to the necessary folders and/or reports
Deploy your web page with the ReportViewer control to your internet server and you are good to go.