troubleshooting Question

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

Avatar of inverted_2000
inverted_2000Flag for United States of America asked on
Microsoft SQL ServerWindows Server 2003Microsoft SQL Server 2005
3 Comments1 Solution4526 ViewsLast Modified:
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?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros