Today I was working on my lab and start working on creating custom reports, but what I found was the following message “The Request Failed with HTTP status 503: Service Unavailable”came up when I click on create Create Report. My first impression was I forgot a pre-req as usual, when we don’t make a check list we do forget stuff. But then I realize there was something more going on on my System Center 2012 Configuration Manager Lab, Is everything Started? Lets validate that. Read More..
To give you more inside on what I did, I launch System Center 2012 Configuration Manager Console. Click on Monitoring Workspace > Reporting > Reports and the click Create Report on the ribbon.
The request failed with HTTP status 503: Service Unavailable.
I check services to make sure all of them where started and I found this one was stopped so I right click Start.
Start SQL Server Reporting Services
But then once I start the service I try again and got this nice message: The Report Builder click-once application does not exist on the report server ‘CM2012.contoso.com’. Ensure that the report builder application manifest exist on the server and try again.
To fix this I went ahead and download Report Builder 3.0.
Once I download the reportbuilder3.msi I then follow the wizard Installation.
When you get to the following screen on the wizard to enter the Default Target Server, Make sure to enter the reporting service point you are using for that site.
Click Next and follow the rest of the wizard screen till finish the installation.
Now that you finish installing the Report Builder we need to do a small change to use it on the registry. I know is a lot of small steps but will be worth it once finishing it.
The following link will give you more information about the process we will perform next.
1. On the computer running the Configuration Manager console, open the Windows Registry Editor.
2. Browse to HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Microsoft/ConfigMgr10/AdminUI/Reporting.
3. Double-click the ReportBuilderApplicationManifestName key to edit the value data.
4. Change ReportBuilder_2_0_0_0.application to ReportBuilder_3_0_0_0.application, and then click OK.
5. Close the Windows Registry Editor.
Now let’s open the System Center 2012 Configuration Manager Console and try to use Create Report.
And done now I can create my custom report, I hope these steps to fix this problem help anyone out there.
Do these steps help you? Leave a comment.