SQL2005 Standard on >2-node cluster?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nils Loeber - 17 Apr 2006 12:03 GMT

Hi all,

is it possible to install SQL Server 2005 Standard Edition on two nodes of a
4-node-cluster? MSFT states that Standard Ed. supports two-node-clusters but
does it also supports a two-node-cluster within a 4-node Windows cluster?

Thanks and best regards
Nils Loeber

Reply to this Message

Rodney R. Fournier [MVP] - 24 Apr 2006 19:46 GMT

Standard will only work on a 2 node.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> Hi all,
>
[quoted text clipped - 5 lines]
> Thanks and best regards
> Nils Loeber

Reply to this Message

Nils Loeber - 25 Apr 2006 23:52 GMT

Hi Rodney,

thanks for your answer. Do you by any chance have a URL or some piece of
documentation as a source or is your comment based on your experience?

Thank you!

Best,
Nils Loeber

> Standard will only work on a 2 node.
>
[quoted text clipped - 17 lines]
>> Thanks and best regards
>> Nils Loeber

Reply to this Message

Rodney R. Fournier [MVP] - 26 Apr 2006 14:22 GMT

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Look under High Availability :) 3 Supports only two nodes.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> Hi Rodney,
>
[quoted text clipped - 27 lines]
>>> Thanks and best regards
>>> Nils Loeber

Reply to this Message

Nils Loeber - 26 Apr 2006 22:21 GMT

Hello Rodney,

yes, I already knew that, but what I would like to know is whether it is
possible to install SQL Standard on only two nodes of a 4-node Windows
cluster. I haven't seen this exact scenario mentioned in any docs (only that
a maximum of two nodes is supported), so if you have specific information on
that I would be grateful.

Best regards,
Nils Loeber

> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>
[quoted text clipped - 41 lines]
>>>> Thanks and best regards
>>>> Nils Loeber

Reply to this Message

Rodney R. Fournier [MVP] - 26 Apr 2006 23:34 GMT

I understand your query now (query, he he - I kill me), it's a gut feeling.
I have never tried it.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> Hello Rodney,
>
[quoted text clipped - 52 lines]
>>>>> Thanks and best regards
>>>>> Nils Loeber

Reply to this Message