Standard or Enterprise for what I am trying to do? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Standard or Enterprise for what I am trying to do?

We are wanting to use a 4 node Windows 2003 Enterprise cluster with 3 (2 node each) SQL Server 2005 Standard instances. I fully understand the physical requirements of setting this up. Node 1 would fail to Node 4
Node 2 would fail to Node 4
Node 3 would fail to Node 4 Node 4 is the passive fail-over for all three SQL Server 2005 (standard) instances. This setup should only require the standard version of SQL Server 2005 since each SQL cluster only has 2 nodes; am I correct in this assumption? Please no speculation, I am looking for replies from folks who know for sure. Yes, I have read Brad M. McGehee’s article "How to Cluster SQL Server 2005" but the article fails to mention the versions (of SQL server 2005) required in the section "Installing Clustering on Multiple Nodes". This is more than anything a budgeting concern as we are trying to make the most of using 2005 Standard and completely avoid purchasing Enterprise. Regards,
-T
If you want to cluster more than two nodes, you must have the Enterprise version of the OS and SQL Server 2005. ——————————–
Brad M. McGehee, SQL Server MVP
http://www.sqlbrad.com
4 Node Windows cluster – Enterprise: Yes
2 Node SQL 2005 Cluster (within that 4 Node Windows Cluster) – ? Standard should be sufficient since the active nodes in that instanced SQL cluster are only 2. Has anyone already tried this specific setup?
I don’t think it is going to work…
SQL SERVER 2005 standard support only two node cluster where as when you install MSCS it will be 4 node…
MohammedU.
Moderator
SQL-Server-Performance.com
I got it to work. A single (3 node) Windows 2003 Enterprise cluster containing 2 (2 node) SQL Server 2005 Standard Clusters. server1(instance A) fails to server3(instance A)
server2(instance B) fails to server3(instance B) I knew it was possible with only SQL Server Standard! Talk about saving a massive amount on licensing.
Thanks for sharing the info and it is very good news… Check with MS about licencing and make sure you don’t break any licence agreement…
MohammedU.
Moderator
SQL-Server-Performance.com
It’s not.
Cool…<br />$$$ Saving <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
KBAhttp://support.microsoft.com/kb/327518 on the subject. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>