Multiple Management Groups, Single Data Warehouse (part 1)

re: Multiple Management Groups, Single Data Warehouse (part 1)

Marnix Wolf — Mon, 22 Jun 2009 21:23:29 GMT

Good article Jonathan. Thanks. A year ago I bumped into a situation with multiple MGs (five in total) and one DW. Got it working but took me a while to figure it out. This article could have spared me a lot of time then.

re: Multiple Management Groups, Single Data Warehouse (part 1)

Marnix Wolf — Fri, 10 Jul 2009 17:54:32 GMT

Hi Jonathan.

How to go about it when upgrading the SQL Server of OpsMgr R2 to SQL 2008? Suppose the OpsMgrDW database server is 2008, does the SRS instances, based on SQL 2005 still work than?

re: Multiple Management Groups, Single Data Warehouse (part 1)

jtalmquist — Fri, 10 Jul 2009 20:45:52 GMT

Hi Marnix,

This is a good question, and I don't recall reading about the shared Data Warehouse upgrade procedures in the R2 Upgrade Guide. I haven't personally tested this scenario, and this is obviously quite a repro setup. I have the question in with the Product Group and will update this comment when I have some answers.

Thanks,

Jonathan

re: Multiple Management Groups, Single Data Warehouse (part 1)

arturlr — Tue, 11 Aug 2009 18:35:54 GMT

Hi Jonathan,

Let's say that I will have 2 RS for SCOM, is there any way to change in the SCOM console the references for the reporting services server?

Thanks,

Artur.

re: Multiple Management Groups, Single Data Warehouse (part 1)

jtalmquist — Wed, 12 Aug 2009 04:18:04 GMT

Arturlr,

I have done this in a lab, and it worked fine. But this configuration is not documented anywhere, so I don't think it's officially supported.

-Jonathan

re: Multiple Management Groups, Single Data Warehouse (part 1)

jtalmquist — Wed, 12 Aug 2009 04:26:08 GMT

@Marnix

Although this *may* work (SQL 2005 SSRS w/ SQL 2008 DW), I haven't personally tested this configuration and there are no plans to include this as a supported upgrade path at this time. Currently, customer needs to upgrade both SQL roles to the same version.

-Jonathan

re: Multiple Management Groups, Single Data Warehouse (part 1)

KAP — Wed, 16 Sep 2009 19:37:29 GMT

I found this article very interesting. Not sure if you can help but....is it possible to install the reporting server component on a SQL cluster (separate instance for SCOM OpsDB, DWDB and RepDB) and during the reporting server wizard can I point the install of the reporting server components on to another server (seperate from cluster)?

re: Multiple Management Groups, Single Data Warehouse (part 1)

jtalmquist — Fri, 18 Sep 2009 09:12:41 GMT

@KAP

The Report Server role is not cluster aware, so it's not advisable to install in a cluster configuration. Also, the SSRS instance needs to reside on the same machine as the Report Server role, as it's outlined above. It's not possible to select a remote SSRS instance while installing the Report Server role.

-Jonathan

re: Multiple Management Groups, Single Data Warehouse (part 1)

KAP — Fri, 18 Sep 2009 11:33:04 GMT

Thanks Jonathan for the information.

So just to confirm, I can install OpsDB and DWDB on the SQL cluster using a tool called DBcreatewizard.exe and I have to install the report server and sql on a standalone server (extra SQL licence). Otherwise installing the reporting role on the cluster would mean SCOM files are installed on the cluster.

re: Multiple Management Groups, Single Data Warehouse (part 1)

jtalmquist — Fri, 18 Sep 2009 18:12:26 GMT

@KAP

That is correct. Unfortunately this all comes down to the fact that the Report Server role is not cluster aware, and needs to be on the same server as the SSRS instance.

-Jonathan