Re: Does SSRS support cluster?

Tech-Archive recommends: Fix windows errors by optimizing your registry



I am not sure what your question is.

The site that you mention states explicitly under the multiple server
configuration that the reporting services database can be on a remote host.
That host can reside on a clustered SQL Server configuration.

What is not supported is clustered Reporting Services nor Report Manager,
which is what the help file states.

Now, as for the requirements for System Center Reporting Manager SQL Server
database engine and warehouse database are not supported in clustered
configurations. This is probably due to the OLAP generation code being
coresident with its proprietary databases.

I do not see the conflict. All of the documents are correct.


Anthony Thomas


--

"Ken" <Ken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7E735A0-4703-48EB-95E2-6B72C87ECF60@xxxxxxxxxxxxxxxx
SQL Server 2005 Reporting Services, Notification Services, and Integration
Services are not cluster-aware; they are always installed as stand-alone
components, but can use a clustered SQL Server database.

Words above come from sql 2005 help on msdn, but the guide of technet for
ms
Reporting Manager 2006 says,

SQL Server Reporting Services (SSRS) must already be installed and
configured before you can install SCRM 2006. Although SQL Server 2005 and
SSRS support a scaled-out deployment model configuration using clustered
servers, SCRM 2006 does not support clustered servers.


Why they are different? which one is correct? Tell me the truth!
Thanks.




.



Relevant Pages

  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • RE: sps Recovery ERROR:database schema is too old to perform
    ... Basically I was trying to use both the content and the configuration ... database files of WSS on a virtual server "MyWSS" that used to ... "MyServer2" with the same virtual server name... ... database server needed to be changed as well. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: major security concern - any sql user with minimal permission can see code for all stored procs
    ... this you may well enter the realm of an unsupported configuration and that's ... > things - and hence has enterprise manager - then this approach won't work. ... > If you just want to lock down a database, then I'd try my approace - lock ... >>> who needed to execute an SP on my server at his location. ...
    (microsoft.public.sqlserver.security)
  • RE: Unable to add Web Reference in Visual Studio 2008 on Win 2003
    ... So the SSRS + MOSS configuration has already been setup, ... We can install SQL 2005 Server with all the features or install just the ... In order to get the integration feature in Reporting Services ... Installing MOSS / WSS3.0 on Reporting Services SERVER1 ...
    (microsoft.public.vsnet.general)
  • Re: Issues with Share Point Services after removing and restoring companyweb
    ... 1.Please check the server configuration at ... click set configuration database server,in the database server textbox,it ... message when you access your Windows SharePoint Services Web site ...
    (microsoft.public.windows.server.sbs)