SQL Reporting Services error browsing localhost/reports “The XML page cannot be displayed” I ran into a new issue during a recent installation of System Center Operations Manager 2007 on Windows 2003 with SQL 2005 SP2.
I’m not sure if it was the order of what prerequisites were applied, or some other spatial anomaly, but the end result was an inability to install the reporting components for Operations Manager 2007. As a background, checking to make sure that the two sql reporting services websites function is a really good idea before attempting to install the OpsMgr reporting components.
Checking the likely issues I browsed to http://localhost/reportserver and http://localhost/reports on the server I was trying to install the OpsMgr components. The reports website was failing with a new error: “The XML page cannot be displayed”. After digging through search engines and trying a variety of different methods to resolve the problem, I found that the following fixed the website:
· From the command prompt, moved into the c:windowsmicrosoft.netframework64v2.0.50727 directory (this was occurruing on a Windows Server 2003 x64 platform so the framework was in the framework64 directory versus the framework directory for x86 systems)
· Ran an aspnet_regiis -u (to remove the v2 version of asp.net)
· Ran an aspnet_regiis -i (to re-add the v2 version of asp.net)
· Ran an iisreset to reset the websites, and re-browsed to the http://localhost/reports and http://localhost/reportserver directories.
The reports virtual was now working correctly. I ended up also needing to use the Reporting Services Configuration tool to apply the default settings to the Report Server Virtual directory to get the http://localhost/reportserver virtual working.
Within the Reporting Services Configuration tool check for any errors. It should be green for the Server Status, Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity, Web Service Identity, Database Setup, Initialization and Execution Account. It was blue for my SharePoint Integration and Encryption Keys, and yellow for my Email Settings.
Once this was done, the installation of the reporting components for Operations Manager 2007 installed without an issue.