One of my colleagues has been fighting the problem installing RS in a scale
out environment and he found a solution that works, but be aware it is not supported by Microsoft!
Part #1
We had planned to use an
existing SQL Server Reporting Services 2005 (SSRS) environment for our SCCM installation.
We installed a new SSRS instance, which became instance number 4, in our existing environment.
When we tried to add the Reporting Services role to SCCM, it picked the first instance, and apparently there where no way to indicate which instance should be used.
According to point 6 in this BLOG: http://blogs.technet.com/configmgrteam/archive/2009/05/14/faq-sql-reporting-services-integration-with-system-center-configuration-manager-2007-r2.aspx, it is not possible to select which instance SCCM will pick for a Reporting Services role.
We did a little testing, and found out that WMI used the following registry folder to enumerate the sites:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQL Server\Instance Names\RS]
We ran an export of this registry key, and then deleted the 3 old instance name values.
Now, when we added the Reporting Services Role to the server, SCCM picked the new instance, that we wanted.
After that, we just imported the reg file again so WMI could see all 4 instances again.
Importing reports to the server now places the reports in the new SCCM Reporting Services instance, and not in our SCOM test instance.
THIS IS NOT an official Microsoft solution, so use it at your own risk, and definitely not mine.
Part #2
We had planned to use a SQL Server Reporting Services 2005 (SSRS) Scaleout environment for our SCCM 2007 R2 installation.
According to Microsoft, this is not a supported option, they only supports multiple independent Reporting Services servers.
This would double the efforts of configuring reports, and demand users to have 2 different URL’s for reporting, and maintain their user configuration and jobs on both servers.
So we tried to setup two SSRS serves, and configured them for Scaleout, see http://technet.microsoft.com/en-us/library/ms159114(SQL.90).aspx and http://technet.microsoft.com/en-us/library/ms156453(SQL.90).aspx.
Then we added the two servers as Reporting Services roles in SCCM, and pointing to one of the servers
imported the reports available.
Because Scaleout deployment uses a shared configuration database, all reports where immediately visible on
the other server.
We put a Cisco Content Switch (CSS) in front of the two SSRS servers, and our users now use a virtual address to run their reports on a available server. NLB could be used as well.
In the Configuration Manager Console, Site Database, Computer Management, Reporting, Reporting Services
there are now 2 servers availble, with all reports defined. When you select a report on one of the servers, that report will run on the selected server. So even from the console, you can select which server should run your report, in case of a disaster on the other server.
This works like a charm, but be aware!
THIS IS NOT an official
Microsoft solution, so use it at your own risk, and definitely not mine.