One Node One Machine Cluster?

Hi,
I am in the process of building a SQL Server "farm," but having to tone down
the pace due to $$. I have just purchased a RAID1 (2 disc/10K rpm/146 GB)
Channel 0, RAID5 (3 disc/10K rpm/146 GB) Channel 1 server with 2 CPU's. This
summer, I plan to buy an identical machine. They will both run Win 2003 EE,
with SQL Server 2000 EE. Rather than install SQL Server locally on my
existing machine, is there a problem with installing MSCS and a virtual
server, even though I only have the one machine now. Of course, it won't
give me failover protection, but it would give me the configuration I want
when I get my second box. Does this make any sense? Any caveats or words of
wisdom?
PS. The servers will be accessed in OTLP mode by an ADO.NET app running on
Terminal Server (Win 2003), and BizTalk Server 2004 - also on a Win 2003 box.
Most of the ADO.NET traffic will occur during business hours, with BTS
getting busy after hours.
Thanks.
John
Hi
Why don't you rather build a single node cluster? Build a normal cluster
node, but not add another node. Once you have bought your other machine, add
it to the cluster.
Just be aware, it is very difficult to get the exact same hardware months
apart. If you are going to use clustering, make sure all the hardware is on
the Windows Hardware Compatibility List (HCL).
A cluster "on the cheap" will just cause you hassles later. I've seen enough
"lets do it with a s little as we can", and the cluster ends up with worse
uptime than a single machine.
Regards
Mike
"JT" wrote:

> Hi,
> I am in the process of building a SQL Server "farm," but having to tone down
> the pace due to $$. I have just purchased a RAID1 (2 disc/10K rpm/146 GB)
> Channel 0, RAID5 (3 disc/10K rpm/146 GB) Channel 1 server with 2 CPU's. This
> summer, I plan to buy an identical machine. They will both run Win 2003 EE,
> with SQL Server 2000 EE. Rather than install SQL Server locally on my
> existing machine, is there a problem with installing MSCS and a virtual
> server, even though I only have the one machine now. Of course, it won't
> give me failover protection, but it would give me the configuration I want
> when I get my second box. Does this make any sense? Any caveats or words of
> wisdom?
> PS. The servers will be accessed in OTLP mode by an ADO.NET app running on
> Terminal Server (Win 2003), and BizTalk Server 2004 - also on a Win 2003 box.
> Most of the ADO.NET traffic will occur during business hours, with BTS
> getting busy after hours.
> Thanks.
> --
> John

On different server?

HI All,
Currently we have two servers in our poduction farm. One runs
sharepoint and the other is the database server. Can i install
reporting services o nthe sharepoint server and tell it point to the
database server? Right now I have it installed the db server, but
would like to move it to the other server.
Any ideas
Thanks!
-SJOn Jul 5, 9:25 am, SJ <sjour...@.gmail.com> wrote:
> HI All,
> Currently we have two servers in our poduction farm. One runs
> sharepoint and the other is the database server. Can i install
> reporting services o nthe sharepoint server and tell it point to the
> database server? Right now I have it installed the db server, but
> would like to move it to the other server.
> Any ideas
> Thanks!
> -SJ
SJ,
Yes, you can install it on the sharepoint server and point it to the
DB server. During installation it will ask you the location of the DB
server.|||Yes, you can install Reporting Services on a computer without SQL Server
installed (as long as it has access to a SQL Server to store its meta data).
However, you need a SQL Server license for the computer where Reporting
Service runs.
"SJ" <sjourdan@.gmail.com> wrote in message
news:1183652738.671128.102340@.n60g2000hse.googlegroups.com...
> HI All,
> Currently we have two servers in our poduction farm. One runs
> sharepoint and the other is the database server. Can i install
> reporting services o nthe sharepoint server and tell it point to the
> database server? Right now I have it installed the db server, but
> would like to move it to the other server.
> Any ideas
> Thanks!
> -SJ
>|||On Jul 5, 1:38 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> Yes, you can install Reporting Services on a computer without SQL Server
> installed (as long as it has access to a SQL Server to store its meta data).
> However, you need a SQL Server license for the computer where Reporting
> Service runs.
> "SJ" <sjour...@.gmail.com> wrote in message
> news:1183652738.671128.102340@.n60g2000hse.googlegroups.com...
>
> > HI All,
> > Currently we have two servers in our poduction farm. One runs
> > sharepoint and the other is the database server. Can i install
> > reporting services o nthe sharepoint server and tell it point to the
> > database server? Right now I have it installed the db server, but
> > would like to move it to the other server.
> > Any ideas
> > Thanks!
> > -SJ- Hide quoted text -
> - Show quoted text -
Thank you both for the reply's I reall appreciate it!
-SJ