View Complete Post
I received a request frm a group here and wanted to run it by the forum just to affirm what I'm thinknig already.
They would like to create a cluster, which in and of itself is no big deal. How they want to is another matter. They currently have a box they want to use as a primary node. They want to install SQL Server on that box. But then they want to create the cluster.
But the shared storage is not available yet.
I told them there's no way to create a cluster without the quorum being there which will be on the shared storage. Actually, they could create the quorum on a local disk, but why????
Eventually this wil be a two node cluster. To me it makes no sense to even try to install a cluster without having the shared storage attached, even if there's only one node in the cluster. It would just be a messy undertaking from my opinion...
I am trying to install SSRS 2008 on a clustered environment. I have found so many contradicting views on web regarding SSRS and clustering. My understanstanding on SSRS and SQL 2008 server cluster(2-node) is that :
1. SSRS2008 is not cluster aware.
2. We can cluster the Reporting Databases. We already have a SQL server 2008 clustering. I guess, we need to install Reporting Databases on both of them.
3. We can install report server on each node in the cluster but that will not be cluster aware(the fail over does not take place).
4. Is there any way we can install report server on a cluster? Right now, we are planning to have one Report server that runs on the sql cluster which has Report databases in it(this way Report databases are clustered). It would be nice if we could
have report server also clustered.