License question

#1

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

#2

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#3

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#4

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#5

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#6

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#7

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#8

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#9

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#10

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.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote

Quote:

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