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