Clustered SQL 2005 Standard

I just completed an install of SQL 2005 Standard into a newly formed
cluster. I basically installed every option for SQL 2005 Server, however,
the only resources added to the cluster group were SQL Server, SQL Agent and
SQL Server Fulltext.
I would have thought reporting services would have been put in there as
well. Is this something I have to add later, or install on each node
separately?
Also forgot to mention, after the install, it didn't put any of the System
DB's into the drive\folder I specified.
So, now I have to go and move them...
Does anyone know of an online tutorial for the new SQL 2005 Interface?
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:eTJ3ULSHGHA.3624@.TK2MSFTNGP09.phx.gbl...
>I just completed an install of SQL 2005 Standard into a newly formed
>cluster. I basically installed every option for SQL 2005 Server, however,
>the only resources added to the cluster group were SQL Server, SQL Agent
>and SQL Server Fulltext.
> I would have thought reporting services would have been put in there as
> well. Is this something I have to add later, or install on each node
> separately?
>
|||Reporting Services is not failover clusterable. It will need to be
installed on each node separately. Since it is a web service, you are
better off setting up a load-balanced web farm with the databases on a
clustered server.
From your followup question: BOL contains some excellent tutorals including
a section on SQL Server Tools.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:eTJ3ULSHGHA.3624@.TK2MSFTNGP09.phx.gbl...
>I just completed an install of SQL 2005 Standard into a newly formed
>cluster. I basically installed every option for SQL 2005 Server, however,
>the only resources added to the cluster group were SQL Server, SQL Agent
>and SQL Server Fulltext.
> I would have thought reporting services would have been put in there as
> well. Is this something I have to add later, or install on each node
> separately?
>
|||Thanks.
How about moving all the DB's to the appropriate drives now?
Looks like it's a little different then in 2000.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:O2kLMmSHGHA.344@.TK2MSFTNGP11.phx.gbl...
> Reporting Services is not failover clusterable. It will need to be
> installed on each node separately. Since it is a web service, you are
> better off setting up a load-balanced web farm with the databases on a
> clustered server.
> From your followup question: BOL contains some excellent tutorals
> including a section on SQL Server Tools.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Kevin Antel" <kevina@.cqlcorp.com> wrote in message
> news:eTJ3ULSHGHA.3624@.TK2MSFTNGP09.phx.gbl...
>
|||ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c466c1670878.htm
Note: This is a link from the December 2005 BOL Refresh for SQL Server
2005. If you are using the RTM BOL, it may not work correctly.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:e60JnoSHGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Thanks.
> How about moving all the DB's to the appropriate drives now?
> Looks like it's a little different then in 2000.
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:O2kLMmSHGHA.344@.TK2MSFTNGP11.phx.gbl...
>