Can an installation of SSRS be used for other reports if the SCOM Reporting Role is installed?
- by Pete Davis
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?