Reporting Services Consolidation
Hi All, I'm have a project to consolidate the environment where today exists 1 server to each product (SharePoint 2010, SCCM 2007 R2, SCOM 2007 and EPM 2010) The Idea is centralize all databases , cubes and Reports in only one server, with its will have one server to each product with all databases, analysis services cubes and Reporting Services Reports in only one server. I read some comments about problems with share the same Reporting Services to SCCM and SCOM, someone know of more any problem or dificult in this task? Feel free to comment here. Thanks all!
November 23rd, 2010 1:26pm

You will need to install multiple Report Server instances on your server. SCCM and SCOM need their own RS instances. SCCM must be the first RS instance. If SharePoint 2010 is running in Integration Mode then it also needs its own RS instance. So, essentially you'll need 4 RS installs with their own set of databases (which can all be in a single SQL Server DB Engine instance either on the same server or on a remote server). It would look something like this: Report Server RS1 - SCCM RS2 - SCOM RS3 - SharePoint Integration Mode RS4 - EPM To simply your configuration, I'd recommend making all RS instances 2008 R2.
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 6:30pm

Hi Stephen, Thanks for your feedback, we prefered adopt another strategy, but thanks anyway!
November 30th, 2010 1:05pm

Hi, just curious what your other strategy was rather then consolidating report servers?
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 1:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics