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.
If you encounter SQL Server instance empty problem when installing Reporting role please read this blog System Center Operations Manager 2016 Step by Step– Part 16 – Installing Reporting role on remote SQL installation? Missing SQL instance!?
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.
Check that you Reporting Services are running.
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.
Open Web Service URL and click apply.
When you click on URL and open it in browser you should get next data. It means Reporting Services are available.
Go to Database page. We need to create Reporting database on SQL server.
Click on change database and choose Create new database
Choose SQL server you will create database on and select account which has enough rights to create database on this server
Give some name to database
Enter service credentials from service account page (Data Warehouse reader account) that will grant that account access to reporting database
Click next on summary page and if everything went successful go finish
Check Web portal URL page
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
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.
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
All prerequisites should be clear
Your SQL Reporting Service instance should be automatically shown on this page, or if there is more then one?! choose yours.
You will enter here you SCOM DWH Data reader account.
Go thru three next pages and start installation. If everything is green, you have SCOM Reporting server installed.