introduction
in previous article : we have got an overview about SSRS and how it’s related with SCOM
this article we will see how to install SSRS and configure it with SCOM
network diagram
please have a look to network diagram below :
we have SCOM server called SCOM142.pioneers.lab
this server also installed SQL 2016 with instance called SCOMINSTANCE
as we mentioned in introduction article : SQL 2016 installation DVD include SSRS as built-in , and there is NO need to download SSRS from MS website
Configuring reporting service Tasks
Configuring reporting service include the following Tasks :
- install prerequisites
- install SSRS
- configure SSRS Database
- Configure SSRS Portal
- Configure SSRS Report server
- install SCOM reporting service
- Configure reporting services with SSRS DB
install prerequisites
- .Net Framework 4.7is required : which already installed during SCOM setup
- It highly recommended to create New SQL instance to avoid conflict with other instance : but here in network pioneers as we are working with testing environment > we will use same instance which called SCOMINSTANCE
- SSRS require SQL.64 edition and will fail if it X86 edition
- Also ACS [Audit Collection services ] require SQLx64 which will be discussed later
install SSRS from SQL setup DVD
we open SQL server with SQL management studio : there is NO DB for reporting
this is very important since some system administrators just select SSRS when setup SQL server and forget it
as we are using SQL 2016 : then we can install SSRS from SQL setup DVD , and there is NO need to download it from MS website
verify SSRS installation
we can verify SSRS installation from from services console > service reporting running
configure SSRS
now it’s time to
- configure SSRS Database
- Configure SSRS Portal
- Configure SSRS Report server
from start menu > open SQL reporting services
verify configure SSRS installation
to verify SSRS configuration :
- new DB created called reportserver
- Web Service URL is http://SCOM142/ReportServer_SCOMINSTANCE
- web portal URL http://SCOM142/Reports_SCOMINSTANCE
Install SCOM reporting Services
no its time to instal SCOM reporting service
verify installing reporting services
to verify installing reporting services
- new workspace created on SCOM server called reporting
- Web Service URL is http://SCOM142/ReportServer_SCOMINSTANCE > report inserted
Conclusion
now SCOM administrator is able to use report in SCOM reporting service