Can an installation of SSRS be used for other reports if the SCOM Reporting Role is installed?

Posted by Pete Davis on Server Fault See other posts from Server Fault or by Pete Davis
Published on 2010-04-20T15:05:23Z Indexed on 2010/04/20 15:14 UTC
Read the original article Hit count: 672

Filed under:
|
|
|

I'm currently in the process of planing a SCOM 2007 R2 deployment and would like to deploy the OperationsManagerDW and Reporting Server to a shared SQL 2008 cluster which is used for reporting across multiple solutions. However in the in the deployment guide for SCOM 2007 R2 it says:

Due to changes that the Operations Manager 2007 Reporting component makes to SQL Server Reporting Services security, no other applications that make use of SQL Server Reporting Services can be installed on this server.

Which concerns me that it may interfere with existing or future (non SCOM) reports in some way even if deployed as a separate SSRS instance. Later in the same guide it states:

Installing Operations Manager 2007 Reporting Services integrates the security of the instance of SQL Reporting Services with the Operations Manager role-based security. Do not install any other Reporting Services applications in this same instance of SQL Server.

Does this mean that I can install a new SSRS instance and use this on the shared cluster for SCOM reporting or that I'd also need to create a whole new SQL Server instance as well as SSRS instance or I'd need a whole separate server for SCOM OperationsManagerDW and Reporitng Server?

© Server Fault or respective owner

Related posts about scom-2007-r2

Related posts about ssrs-2008