In setting up a 2-node cluster (active/active) do I need to have an
additional SQL 2005 Enterprise license for the second node?
Also, I'm new to clustering and I just want to verify that I can do an
active/active 2-node clustering with SQL 2005? I see alot of talk about
active/passive but I'd rather have active/active and was wondering if there's
a limitation or particular reason for active/passive
Geoff N. Hiten - 25 Aug 2008 16:15 GMT
You will need to license any nodes that have an active SQL instance hosted
on them. If you have a single-instance cluster with two nodes, then one is
always a failover node and does not require a license. If you have 4 nodes
and three instances, you still have a failover node and only have to license
three instances.
Two nodes with two or more instances require full licensing of both nodes.

Signature
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
> In setting up a 2-node cluster (active/active) do I need to have an
> additional SQL 2005 Enterprise license for the second node?
[quoted text clipped - 4 lines]
> there's
> a limitation or particular reason for active/passive
Mohit K. Gupta - 28 Aug 2008 17:16 GMT
Since you are setting up active-active, you require two license I belive.
But thing you have to consider about active-active is if either partner
fails; the remaining partner will take the full load. So when configuring
hardware for the server make sure it is configured to handle 2x its normal
load.
Thanks.

Signature
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/
> In setting up a 2-node cluster (active/active) do I need to have an
> additional SQL 2005 Enterprise license for the second node?
[quoted text clipped - 3 lines]
> active/passive but I'd rather have active/active and was wondering if there's
> a limitation or particular reason for active/passive