inverted_2000
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 :)
<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 :)
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