System Center Operations Manager 2016 Step by Step–Part 6

Lets install Reporting server now. I needed to change my design because I read note below on TechNet. It means if you use web console and want to access Reporting, you will not be able to access it if you installed this role on server different than web console role server. So I needed to install reporting services on management server and not on SQL server like I planed.

On the same TechNet link you can find all steps required to check if your Reporting services are configured correctly. Still, if you pass next steps, you are good to install SCOM Reporting server.

 

Although SQL Server Reporting Services is installed on the stand-alone server, Operations Manager reports are not accessed on this server; instead, they are accessed in the Reporting workspace in the Operations console. If you want to access published reports via the web console, you must install the Operations Manager web console on the same computer as Operations Manager Reporting server.

 

I installed Reporting Services (in Native mode) on server. Open Reporting Services Configuration Manager and connect to you Reporting instance to configure it.

image

Check that you Reporting Services are running.

image

Go to Service accounts. You need to enter here you Data warehouse reader account. When you enter it it will ask you for backup encryption key location and password. It is used to encrypt all communication of Reporting service. Store it on safe place together with password. image

image

Open Web Service URL and click apply.

image

When you click on URL and open it in browser you should get next data. It means Reporting Services are available.

image

Go to Database page. We need to create Reporting database on SQL server.

image

Click on change database and choose Create new database

image

Choose SQL server you will create database on and select account which has enough rights to create database on this server

image

Give some name to database

image

Enter service credentials from service account page (Data Warehouse reader account)  that will grant that account access to reporting database

image

Click next on summary page and if everything went successful go finish

image

Check Web portal URL page

image

Click Apply and check url in browser. You should get this web page if everything is fine. This is SSRS 2016 so page may look different if you use another SQL version

image

On Execution account  page enter DWH reader account again. One more thing to check. Go to Scale-out Deployment. Your Reporting Services server should be joined.

image

That all regarding configuring  SSRS for SCOM Reporting server. Now lets install SCOM Reporting server. Before setup check Remote registry service. It should be started and startup need to be automatic on SCOM Reporting server. Run setup and choose this role to install

image_thumb65

All prerequisites should be clear

image

Your SQL Reporting Service instance should be automatically shown on this page, or if there is more then one?! choose yours.

image

You will enter here you SCOM DWH Data reader account.

image

Go thru three next pages and start installation. If everything is green, you have SCOM Reporting server installed.

image