SCOM Reporting Services Part II: Installation & Configuration

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email
Table of Contents

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   

network diagram

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 

open SQL Mgmt Studio
there is ONLY DB or SCOM and NO DB for SSRS

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 

run SQL setup from DVD
nre installation or add feature
NO error with SQL > regarding firewall don't worry since it's controlled by GPO
as we said earlier > it's recommended to install SSRS on new instance > but here in testing env we will install on same instance
select reporting service SSRS
run service by somain account pioneers\sqladmin
install ONLY
review and install
SSRS installation DONE

verify SSRS installation

we can verify SSRS installation from from services console > service reporting running

SSRS in services console

configure SSRS

now it’s time to 

  • configure  SSRS Database 
  • Configure SSRS Portal 
  • Configure SSRS Report server 

from start menu > open SQL reporting services 

from start menu > open SQL reporting services 
select SQL server instance
check service running account
web service URL
move to database and create new one
test connection to service with account scom admin
set DB name
select credential
review and next
DB created successfully
email setting is optional

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
  •  
new DB created called reportserver 
• web portal URL http://SCOM142/Reports_SCOMINSTANCE > please note NO reporting created > which will done with SCOM reporting services
• Web Service URL is http://SCOM142/ReportServer_SCOMINSTANCE

Install SCOM reporting Services

no its time to instal SCOM reporting service 

run SCOM setup
since SCOM is already installed > add feature
select reporting server
all prerequisites pass
select server and instance
which account is Data Reader account
next
review and install
installation DONE

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 
  •  
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 

Share this post
Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email

About Me

Our Power in Numbers

 17 

Courses

321

Articles

3,882

Images
and All configurations images are proudly made in Pioneers Lab

Articles By Course

Recent Articles

Subscribe

Contact us

have a challenge ? don’t hesitate to contact us