Discussion:
Reporting Components setup
(too old to reply)
Jorge
2009-08-19 10:15:01 UTC
Permalink
Hi,

I'm a bit confuse about reporting components and where to place them.

Firstly, I would like to know if it's possible to install SQL reporting
services on the SQL server that hosts the Operation and Data Warehouse
databases and install the SCOM reporting services on the RMS.

Secondly, it would be great if someone could give to me some good practices
regarding reporting components setup.

Thanks,
Jorge Q
Jorge
2009-08-19 10:17:02 UTC
Permalink
In addition, I have some doubts about if SQL Reporting services can be
installed on a separate SQL instance.

Thanks again,
Jorge Q
Post by Jorge
Hi,
I'm a bit confuse about reporting components and where to place them.
Firstly, I would like to know if it's possible to install SQL reporting
services on the SQL server that hosts the Operation and Data Warehouse
databases and install the SCOM reporting services on the RMS.
Secondly, it would be great if someone could give to me some good practices
regarding reporting components setup.
Thanks,
Jorge Q
GD
2009-08-24 06:18:37 UTC
Permalink
All are possible - what is best depends on your environment and hardware.
http://blogs.technet.com/momteam/archive/2008/03/28/operations-manager-reporting-supported-ssrs-configurations.aspx

You should use a dedicated instance of SQL Reporting Services as the opsmgr
install imposes its own security model that will "break" other applications
that are using SQL RS.

Cheers

Graham
Post by Jorge
In addition, I have some doubts about if SQL Reporting services can be
installed on a separate SQL instance.
Thanks again,
Jorge Q
Post by Jorge
Hi,
I'm a bit confuse about reporting components and where to place them.
Firstly, I would like to know if it's possible to install SQL reporting
services on the SQL server that hosts the Operation and Data Warehouse
databases and install the SCOM reporting services on the RMS.
Secondly, it would be great if someone could give to me some good practices
regarding reporting components setup.
Thanks,
Jorge Q
Continue reading on narkive:
Loading...