Hi all!
how many failover nodes are supported by SQL SRV 2k on a windows server 2k3
EE cluster?
I have only found information about 4 failover nodes on 64 edition of sql.
Tks in adv.
Regs.

SQL2000 supports whatever the OS supports. On Windows Server 2003 Enterprise
Edition that would be 8

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Axyl104" <telodico (AT) te (DOT) it> wrote

SQL 2000 supports a maximum of 4 nodes in a cluster.

PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
Nodes
http://support.microsoft.com/default...&Product=sql2k


--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:u0V01K2XEHA.3520 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

I agree but at Tech Ed 2004 USA someone from Microsoft said what I wrote, in
a SQL 2005 presentation. Since I have not tested it. I am going with what
the MS Employee said at Tech Ed.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

When I asked this question earlier, I got a direct reply from the
Microsoftie who was program manager of the install team. 4 nodes is all you
get with SQL Server 2000. It is due to a limit in the installer, not a SQL
cluster limit per se.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:ulx75u3XEHA.1652 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

SQL Server 2000 Failover Clustering (32-bit) supports four nodes on Windows 2003 Enterprise Ed cluster server (even though Windows 2003 EE supports 8 nodes).

SQL Server 2000 Failover Clustering (64-bit) supports upto eight nodes on Windows 2003 EE (64 bit) and Windows 2003 DataCenter (64-bit) server cluster.

Rod --- you said "I agree but at Tech Ed 2004 USA someone from Microsoft said what I wrote, in
a SQL 2005 presentation. Since I have not tested it. I am going with what
the MS Employee said at Tech Ed."

--- SQL 2005 presentation ==> Yukon - our next release. You go the right information. i.e. in SQL 2005, we will support 8 nodes.

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx