troubleshooting Question

SCOM 2012 - Datawarehouse without SQL Reporting

Avatar of Cyclops3590
Cyclops3590Flag for United States of America asked on
Microsoft ApplicationsMicrosoft Server Apps
3 Comments1 Solution2100 ViewsLast Modified:
I am deploying SCOM 2012 soon.  The design I was given shows nothing for a SQL reporting services server anywhere.  I'm told that since part of the design calls for a datawarehouse database that we must have a SQL reporting services server installed as well.

What I want to know is why.  It's my understanding that the mgmt servers will populate the DW db and via the consoles be shown to users.  So what does the SQL reporting services add for me and if it truly is required to be deployed when deploying the datawarehouse db, why it's required.  What breaks if it's not there or does it just not let you install the DW db even?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros