No report builder models are available. To use Report Builder, at leasetr one model must be published to the report server

Most have you will have clicked on the ‘Design a new report’ button and found that there were ‘No Data Sources available’.

Here is how you can setup this feature for SCOM 2007.

CREATE A REPORT MODEL

1. Open SQL Server Business Intelligence Development Studio
2. Click File -> New -> Project
3. Select Report Model Project
4. Fill in a Name and Location
5. Click OK

CREATE A DATA SOURCE

1. In Solution Explorer, right-click Data Sources, Click Add New Data Source

2. Click Next on the Welcome Screen
3. Click New
4. Fill in the connection to the SQL Server and Instance (ie: SERVER\INSTANCE) to your SCOM Database
5. Select the Database you want to interact with. (ie: OperationsManagerDW)

6. Click OK
7. Click Finish

You will now see the Data Source under Solution Explorer

CREATE A DATA SOURCE VIEW

1. In Solution Explorer, right-click Data Sources, Click Add New Data Source View
2. Click Next
3. Select the data source from the Relational data souces: panel
4. Click Next
5. This is the part where you need to think, You will need to select the tables and views you want to include in the model. If you not sure and just want to play around you can however I would not suggest it… but you can sellect all the tables, however leave the views out as they can cause issues.
6. Click Next
7. Click Finish

You will now see the Data Source View under Solution Explorer

CREATE A REPORT MODEL

1. In Solution Explorer, right-click Data Sources, Click Add New Report
2. Click Next
3. Select the Data Source and Click Next
4. Select the Model Rules and Language (If unsure, keep the defaults) Click Next
5. Select Update model statistics before generating and Click Next
6. Type in a name Name and Click Run

Note: This may take some time depending on the number of Tables and Views selected when creating the Data Source View.

7. Click Finish
8. Under Solution Explorer Right-Click the new Report Model and selct Deploy

9. Exit SQL Server Business Intelligence Development Studio and Save.

RUN DESIGN A NEW REPORT

1. Open System Center Operations Manager Console
2. In Report Click Design new report
3. Report Builder will launch and you will see a Data Source
4. Highlight it and Select a Report Layout Click OK

Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\RSReportServer.config' is denied

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\RSReportServer.config' is denied.

Solution:

1. Right click RSReportServer.config file
2. GO to Properties
3. Click Security tab
4. Click Add button
5. Type "Network Service" and select "Location" as local PC.
6. Click "Check Names" button
7. Click OK; OK and you it should work now.

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Access to the path 'c:\inetpub\wwwroot\web.config' is denied.

Source Error:

[No relevant source lines]

Source File: c:\inetpub\wwwroot\web.config Line: 0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Solution:

1. Check if the reportserver is running in your machine.
2. Also check if the IIS is properly configured in the machine
3. Delete Web.Config in c:\InetPub\wwwroot.

(NOTE: A common configuration mistake is to have both SSRS and SharePoint in the default web site. When SharePoint is installed it takes over the default website. SSRS website should be changed to listen on a different port, e.g. port 8080; use http://localhost:8080/reports for Report Manager and http://localhost:8080/ReportServer for Report Server if you got sharePoint installed on same server)