Re: Clustering Question

Bryan,

you cannot install Cluster (MSCS) on a Small Business Edition, you need
Enterprise Edition or Datacenter.

And what are you doing with Cable connections and DSL connections ?
If you are clustering an SQL server (as per all posts in this thread) surely
you want to do this behind a firewall, not connected to the internet.

Rgds,
Edwin.

"Bryan Krossley" <krossley@xxxxxxxxxxxxxx> wrote in message
news:%23Hx4KsgIIHA.6068@xxxxxxxxxxxxxxxxxxxxxxx
So let me see if I have this right. Here is what my situation is.

I will have two computer (nodes)
One computer will have Window Server Small Business Edition with Cable
Internet
The Other computer will have Window Server Small Business Edition With DSL
Internet And 1 Instance of SQL Server Edition deployed to both machines.

Is this correct?

Thanks,

Bryan


"Russ Kaufmann [MVP]" <russ@xxxxxxxxxxxxxxx> wrote in message
news:363DBB7D-2DF9-4485-831E-3E53DB004A32@xxxxxxxxxxxxxxxx
"Bryan Krossley" <krossley@xxxxxxxxxxxxxx> wrote in message
news:OSIqHu8FIHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for all the replies. But I am a little confused. If both
machine
don't have Sql installed and running how would they be redundant?
Would
you not need at least two machine running the same software?

When you install an instance on a cluster, you install the instance (the
install of SQL) to all nodes if you want to allow it to run on all
nodes.
When you install a second instance (another installation of SQL in a
different location), then you install it to all nodes if you want it to
be
able to run on all nodes.

Then, to make it active/active, you run one instance on one node and run
the other instance on the other node.

Thus, instance1, if it fails on its active node, it will failover to the
other node because all of the installation files are there for that
instance. If instance2 fails on its active node, it will failover to the
other node because all of the installation files are there for that
instance, too.

Refer to the books online for more information about instances and how
to
install SQL on a cluster.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York



.

Relevant Pages

  • Re: Clustering Question
    ... The Other computer will have Window Server Small Business Edition With DSL Internet And 1 Instance of SQL Server Edition deployed to both machines. ... When you install an instance on a cluster, you install the instance to all nodes if you want to allow it to run on all nodes. ...
    (microsoft.public.windows.server.clustering)
  • Re: Pervasive SQL Clustering
    ... So, in effect, I've got services running on the cluster and both nodes. ... Is it possible to install and application to the cluster rather than the ... > setting up a Generic Service resource, you might find this topic from Help ... > or application highly available using Generic Service or Generic Application ...
    (microsoft.public.windows.server.clustering)
  • Re: sql 2005 cluster setup questions
    ... Thanks again, Geoff. ... Here is the official instructions on how to rip SQL 2005 out by the roots. ... to 2nd node to install work station component, ... want to take Microsoft recommended approach not to cluster SSIS but I ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL2K setup fails on 2K3 Cluster...Cant create Virtual Srvr r
    ... TS and Remote Desktop are NOT the same. ... should not interfere with the install, however, do not remote into the ... All 3 of the accounts you mention are in use ... the cluster VIP and name did get registered in the DNS table. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... However, as far a clustering SQL Server, my prior post lists the steps. ... and how many cluster resource groups for this instances. ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)