Link to home
Start Free TrialLog in
Avatar of inverted_2000
inverted_2000Flag for United States of America

asked on

SQL Server 2005 Standard Edition - Cluster with ACTIVE / ACTIVE / ACTIVE / PASSIVE

Hey all,

I've got a systems that is already in place that runs 3 HP blades (Dual Quad Core Xeon / 16GB memory), Windows 2003 R2 Enterprise, and SQL Server Standard 2005 SP2.  All software is x64.
This configurateion runs:
(ACTIVE / ACTIVE / PASSIVE)
as
(DB / Reporting /Passive Failover)

My boss wants to add a 4th node to this Standard Edition cluster for a new SharePoint DB.
This would share the Passive node with the other 2 nodes that are already in place.
Remember this is standard edition SQL Server.

So a new HP Blade running Server 2003 R2 EE with SQL Server Standard 2005 SP2 is brought online.

We run through the SQL server setup and it looks okay with the clustering setup in SQL Server...but it stops and throws the out that we need to pick additional nodes to be a part of the virtual server.  It has the new node selected "Svr4DB" but the other 3 nodes are listed as unavailable:

Svr1DB - A SCC check failed on the node
Svr2DB - A SCC check failed on the node
Svr3DB - A SCC check failed on the node

Does this mean that it's not going to allow another node into the Single Copy Cluster (SCC) setup?

Thanks peeps...and would upgrading to EE SQL Svr fix this?
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

yes, you need EE edition:
Standard Edition  Supports two-node clustering support for the Database server only.
 
see
SQL Server 2005 Features Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx 
ASKER CERTIFIED SOLUTION
Avatar of inverted_2000
inverted_2000
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You asked:
<My boss wants to add a 4th node to this Standard Edition cluster for a new SharePoint DB.
This would share the Passive node with the other 2 nodes that are already in place..>
I answered :
<Standard Edition  Supports two-node clustering support for the Database server only. > 
---
last one was : They are all 2 node clusters...just 3 separate one's that shared the same failover node.
----------------------
<you didn't read or understand the question completely.>
 I can not read your mind :)