Clustering SQL Server 2000 Analysis Services

We are in the process of deploying AS on a 2-node Active-Passive SQL Server
2000 MSCS cluster. I understand there is a MS white paper on how to cluster
it which requires lots of manual changes. If we were to follow this paper,
would it be possible to have the AS tools shared across with other SQL
virtual servers on the same cluster? Any experiences with this configuration
are appreciated.
NewsgroupUser wrote:

> We are in the process of deploying AS on a 2-node Active-Passive SQL Server
> 2000 MSCS cluster. I understand there is a MS white paper on how to cluster
> it which requires lots of manual changes. If we were to follow this paper,
> would it be possible to have the AS tools shared across with other SQL
> virtual servers on the same cluster? Any experiences with this configuration
> are appreciated.
I've used reciently that paper (http://support.microsoft.com/?kbid=308023)
with a virtual cluster over Microsoft Virtual Server 2005/Win2K3, and
really works.
I've tested failover and no problems..
coke.cl [-en-] gmail.com
http://www.foto-digital.cl/

Clustering Reporting Services

Hello,
I'm running a two node cluster, Windows 2003 R2 and SQL 2005. Does anyone
have a white paper or documentation that tells me how to install Reporting
Services as a clustered service? I've never set up a web farm or anyting of
that nature, so any information regarding this would be greatly apprecaited.
Thank you
Alex AndersonI have the same issue here, I'll start installing an active-active cluster
this week and I need to install reporting services on the cluster.
What is the best way to do this.
I asume that reporting services is not cluster aware.
Regards
"Alex Anderson" wrote:
> Hello,
> I'm running a two node cluster, Windows 2003 R2 and SQL 2005. Does anyone
> have a white paper or documentation that tells me how to install Reporting
> Services as a clustered service? I've never set up a web farm or anyting of
> that nature, so any information regarding this would be greatly apprecaited.
> Thank you
> Alex Anderson
>|||Zekske,
What I found out was, depending what version of SQL 2005 you have, I have
standard 2005 which even though SQL is clusterable, reporting services is
not. You will need Enterprise SQL 2005 to be able to cluster reporting
services. I'm just going to run a non-clusterable version of reporting
services.
"Zekske" wrote:
> I have the same issue here, I'll start installing an active-active cluster
> this week and I need to install reporting services on the cluster.
> What is the best way to do this.
> I asume that reporting services is not cluster aware.
> Regards
> "Alex Anderson" wrote:
> > Hello,
> >
> > I'm running a two node cluster, Windows 2003 R2 and SQL 2005. Does anyone
> > have a white paper or documentation that tells me how to install Reporting
> > Services as a clustered service? I've never set up a web farm or anyting of
> > that nature, so any information regarding this would be greatly apprecaited.
> >
> > Thank you
> > Alex Anderson
> >|||OK thanks.
We're installing Enterprise Edition so we'll try the clustering...
Regards
"Alex Anderson" wrote:
> Zekske,
> What I found out was, depending what version of SQL 2005 you have, I have
> standard 2005 which even though SQL is clusterable, reporting services is
> not. You will need Enterprise SQL 2005 to be able to cluster reporting
> services. I'm just going to run a non-clusterable version of reporting
> services.
> "Zekske" wrote:
> > I have the same issue here, I'll start installing an active-active cluster
> > this week and I need to install reporting services on the cluster.
> > What is the best way to do this.
> > I asume that reporting services is not cluster aware.
> > Regards
> >
> > "Alex Anderson" wrote:
> >
> > > Hello,
> > >
> > > I'm running a two node cluster, Windows 2003 R2 and SQL 2005. Does anyone
> > > have a white paper or documentation that tells me how to install Reporting
> > > Services as a clustered service? I've never set up a web farm or anyting of
> > > that nature, so any information regarding this would be greatly apprecaited.
> > >
> > > Thank you
> > > Alex Anderson
> > >

cluster white paper

Is there a reliable white paper for clustering sql2k on win2k3. Ive already
got the OS clustered.
SQL2K SP3
TIA, ChrisR
ChrisR wrote:
> Is there a reliable white paper for clustering sql2k on win2k3. Ive
> already got the OS clustered.
Some of these might help:
http://www.microsoft.com/resources/d...rt4/c1261.mspx
http://support.microsoft.com/default...lurb101802.asp
http://msdn.microsoft.com/library/de...ering_2icn.asp
David Gugick
Imceda Software
www.imceda.com
|||This is great information. Does anyone have any updated information on
setting up SQL Server 2000 in a Windows 2003 environment?
Just wondering if 2003 brings anything more to the table over Windows Server
2000.
Thanks!
Tony
"David Gugick" wrote:

> ChrisR wrote:
> Some of these might help:
> http://www.microsoft.com/resources/d...rt4/c1261.mspx
> http://support.microsoft.com/default...lurb101802.asp
> http://msdn.microsoft.com/library/de...ering_2icn.asp
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

cluster white paper

Is there a reliable white paper for clustering sql2k on win2k3. Ive already
got the OS clustered.
--
SQL2K SP3
TIA, ChrisRChrisR wrote:
> Is there a reliable white paper for clustering sql2k on win2k3. Ive
> already got the OS clustered.
Some of these might help:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part4/c1261.mspx
http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fwcd101802%2Fwcdblurb101802.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
--
David Gugick
Imceda Software
www.imceda.com|||This is great information. Does anyone have any updated information on
setting up SQL Server 2000 in a Windows 2003 environment?
Just wondering if 2003 brings anything more to the table over Windows Server
2000.
Thanks!
Tony
"David Gugick" wrote:
> ChrisR wrote:
> > Is there a reliable white paper for clustering sql2k on win2k3. Ive
> > already got the OS clustered.
> Some of these might help:
> http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part4/c1261.mspx
> http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fwcd101802%2Fwcdblurb101802.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> --
> David Gugick
> Imceda Software
> www.imceda.com
>