Publishing SQL reports

This recipe will describe the steps you need to publish reports to your SQL reporting server.

In this recipe, we will look at scenarios for which we require access to your newly created SQL reports from within the SCOM console.

Getting ready

The preparation for this recipe is to ensure you have the appropriate access to your SCOM reporting server.

How to do it...

Perform the following steps to publish your SQL report to your SCOM reporting server:

1. Start the Microsoft Report Builder 3.0 application.

2. Click File | Open.

3. Navigate to the location of the DistributedApplicationReport.rdl file you saved in the previous recipe, select the file, and click Open.

4. Click File | Save As.

5. In the Name textbox, type the web address of your Operations Manager reporting server and click Save.

6. Once you are connected to your SQL report server, double-click on the folder named My Reports. Now, in the Name textbox, type Distributed Applications and click Save:

   

7. Close the Microsoft Report Builder 3.0 application...