How many SQL 2000 nodes does Microsoft Officially Support on 2003?

I would like to know if I can move my active/passive SQL clusters into a more
cost effective four node cluster (3 active and 1 passive). Is there a matrix
or document somewhere on Microsoft's site that indicates what configurations
are officially supported and considered "best practices"?
I found this document
http://www.microsoft.com/technet/pro...rt4/c1261.mspx
which indicated this configuration is good to go on a Windows 2000
Datacenter OS. I believe the document is dated. With the advent of Server
2003, is a four none cluster supported on 2003 Enterprise? Is there a
document that backs this up?
Continuing on this thread, is there any type of matrix that shows what
Microsoft supports from an OS and Application standpoint for two, four, more
node clusters?
Thank you in advance for any assistance.
- John
You can build a 4 node cluster on Windows 2003 using SQL 2000.
PRB: Virtual SQL Server 2000 installation fails on cluster that has eight
nodes
http://support.microsoft.com/kb/811054/en-us
I have built and operated a 4-node, 3 instance SQL 2000/Windows 2003
Enterprise Edition cluster. The procedures and practices are a bit more
complex than a two-node cluster, but nothing radically different.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"John Robel" <John Robel@.discussions.microsoft.com> wrote in message
news:7723B6AA-72AF-4B5B-91E1-7CEF9F19DBC7@.microsoft.com...
>I would like to know if I can move my active/passive SQL clusters into a
>more
> cost effective four node cluster (3 active and 1 passive). Is there a
> matrix
> or document somewhere on Microsoft's site that indicates what
> configurations
> are officially supported and considered "best practices"?
> I found this document
> http://www.microsoft.com/technet/pro...rt4/c1261.mspx
> which indicated this configuration is good to go on a Windows 2000
> Datacenter OS. I believe the document is dated. With the advent of
> Server
> 2003, is a four none cluster supported on 2003 Enterprise? Is there a
> document that backs this up?
> Continuing on this thread, is there any type of matrix that shows what
> Microsoft supports from an OS and Application standpoint for two, four,
> more
> node clusters?
> Thank you in advance for any assistance.
> - John
sql

How Many IP(Public & Private) Required for 2 Node Active/Passive Cluster

Hi all,

I have some doubt about the IP Required for configuring cluster(both Window and SQL server)

Details :
-
How Many IP(Public & Private) Required for 2 Node Active/Passive both window and SQL server Cluster ?
IP(Public & Private) Required :

1 : For Window Clustering : 2 node Active/Passive Cluster ? How many ip ?
2 : For Sql Server Clustering : 2 node Active/Passive Cluster ?how many ip ?
3 : Is there any mathematics for that ? How to analyse the IP requirement ?

Thanks

Hi all,

Can u plz.....

sql

How Many IP(Public & Private) Required for 2 Node Active/Passive Cluster

Hi all,

I have some doubt about the IP Required for configuring cluster(both Window and SQL server)

Details :
-
How Many IP(Public & Private) Required for 2 Node Active/Passive both window and SQL server Cluster ?
IP(Public & Private) Required :

1 : For Window Clustering : 2 node Active/Passive Cluster ? How many ip ?
2 : For Sql Server Clustering : 2 node Active/Passive Cluster ?how many ip ?
3 : Is there any mathematics for that ? How to analyse the IP requirement ?

Thanks

Hi all,

Can u plz.....

How many Enterprise Licenses to Buy?

We are building up a clustered server configuration with two nodes. Each
node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
to buy two Enterprise licenses (one for each 4-processor server) or 8
licenses (one for each processor on each server)? I am getting conflicting
information on this. Thanks for any info.How many instances are you going to run in the cluster? You license per active instances (unless you
will run several instances in the same node, i.e., the other node doesn't do any SQL Server
processing at all). And, if you license per processor, you need to multiply with the number of
processor sockets you use in the machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting conflicting
> information on this. Thanks for any info.|||It depends.
First, check with your local Microsoft office. Make sure you have a person
knowledgable about SQL licensing in a clustered environment.
Here is the base page with links to the licensing information:
http://www.microsoft.com/sql/howtobuy/default.mspx#EEAA
Here is the FAQ page
http://www.microsoft.com/sql/howtobuy/faq.mspx
The relevant question and answer are here:
Q. How does licensing work for computers that run SQL Server 2005 in
failover scenarios?
A. Failover support, where servers are clustered together and set to
pick up processing duties if one computer should fail, is now available in
Workgroup, Standard, and Enterprise editions of SQL Server 2005. Under each
of these editions, keeping a passive server for failover purposes does not
require a license as long as the passive server has the same or fewer
processors than the active server (under the per processor scenario). For
details on which failover methods are available under each edition, visit
the SQL Server 2005 Features Comparison page.
Finally, SQL 2005 supports failover clustering on Standard Edition with up
to four processors on each host. If you do not need any other Enterprise
Edition features, you will save a considerable amount of money on licensing
by using Standare Edition. Oh, and look at the DL/ML 585 series wutl
Dual-Core processors. IMHO, the best bang for the bucks.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we
> need
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting
> conflicting
> information on this. Thanks for any info.|||We will not be doing any processing on the non-active server. From the MS
web link posted by Tibor (thank you), it looks like we need only the Server
Plus Device CALs model. There will be no web access and I know exactly how
many users will get to it at all times. I had trouble finding where it says
we don't need a license for the passive failover option. Could you send me a
link? That sounds like what we need. Do I then need CALs for each user?|||Search for "failover" in the FAQ page.
As for the licensing, since you don't have any internet access to the
server, choose whichever licensing model (per-processor or CAL) is cheaper.
That is why Microsoft has multiple licensing models.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:BB370D4D-88FB-4ACC-B8E1-A82932038125@.microsoft.com...
> We will not be doing any processing on the non-active server. From the MS
> web link posted by Tibor (thank you), it looks like we need only the
> Server
> Plus Device CALs model. There will be no web access and I know exactly
> how
> many users will get to it at all times. I had trouble finding where it
> says
> we don't need a license for the passive failover option. Could you send
> me a
> link? That sounds like what we need. Do I then need CALs for each user?
>|||Thank you. BTW, I did find the FAQ site on licensing. Thanks very much for
your help. I don't think our software supplier is asking us the right
questions, as they went straight for the per-processor option even though the
device CALs option is much better suited for our situation.|||If I already have device CALS for existing SQL servers, do I need to buy new
ones for a new SQL server I am installing or do I just buy the server
license? It looks like the device CAL is good for connections to any number
of different servers, so long as each server has a license.
When doing that install on a new server, do I have to tell it how many CALs
I bought or is it basically the honor system?
I have seen some folks wondering how to enter the number of CALs. If I add
more CALs, do I need to tell my instance of SQL server how many I added?|||A Device CAL can connect to any number of SQL servers.
There is no technical enforcement measure for CAL enforcement built into SQL
Server. It is a good idea to set up a licensing server and funnel CAL
configuration through that so you have a single point of maintenance.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:DF76E12F-B60D-48B2-BFB6-5A4364B46F95@.microsoft.com...
> If I already have device CALS for existing SQL servers, do I need to buy
> new
> ones for a new SQL server I am installing or do I just buy the server
> license? It looks like the device CAL is good for connections to any
> number
> of different servers, so long as each server has a license.
> When doing that install on a new server, do I have to tell it how many
> CALs
> I bought or is it basically the honor system?
> I have seen some folks wondering how to enter the number of CALs. If I
> add
> more CALs, do I need to tell my instance of SQL server how many I added?