December 15, 2010 at 9:18 am
I have an existing SQL 2008 R2 Enterprise cluster (2-node, active/passive). During the initial setup, I did not install the Analysis Services or Reporting Services components. However, now a need for these components has come up. Can I add these components to the existing cluster installation?
Thank you!
December 15, 2010 at 10:30 am
The short answer is yes you can. But with respect to SSRS I would not install this on the cluster with SQL. I don't believe it is cluster aware. see http://msdn.microsoft.com/en-us/library/bb522745.aspx It should be installed on its own server (perhaps load balanced) The databases could still be on your existing SQL Server but the service itself should be installed elsewhere. The databases will be created when you configure SSRS. If you do decide to load balance SSRS on the new server, then you could use a feature called Network Load balancing on windows server 2008.
Francis
December 15, 2010 at 12:03 pm
As Francis mentioned, SSRS is not clustered aware. So the recommended aproach is to Install SSRS on a standalone server and put the SSRS dbs on the clustered instance.
I think SSAS cannot be added to the existing Clustered SQL Server Instance or to the existing SQL Server Instance resource group. I think you may have to do a seperate installation.
Please check the following from the Microsoft Whitepaper
"Note: SQL Server 2008 does not support adding features to an existing failover cluster instance, so Analysis Services cannot be added to an existing instance of SQL Server. To share a resource group with an instance of SQL Server, you must choose to install Analysis Services during the initial installation of SQL Server."
Thank You,
Best Regards,
SQLBuddy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply