Rick,
while you actually can install another SQL Server instance on the second
node (or even on the first one - which is possible in a non-clustered setup
as well), unless you make it part of a separate resource group, you won't be
able to take advantage of benefits offered by clustering. So the
recommendation from your "Windows guy" is valid...
Note that "Active/Active" in this context means that you have two (or more)
instances of SQL Server running simultaneously on the cluster nodes within
distinct resource groups. This does not imply in any way that they share the
same set of databases.
hth
Marcin
"Rick" <> wrote in message
news:51B5EB16-5286-43E2-ADFE-...
> We have a Active\Passive cluster set up with one virtual node set up. It
> has
> one instance of SQL Server running on it. I want to install another
> instance
> of SQL server on it and run it on the second node (Thus making it
> active\active). However my windows guy thinks we need to install another
> virtual node on the cluster? I do not ever remember having to do that in
> the
> past (I have installed SQL on clusters dozens of times) and want to find
> out
> if he is correct. (He has only installed a clustering services once) Any
> thoughts?
|