which SQL Server 2000 license to purchase

[FALCONSEYE]

Ok, we need to purchase a license enterprise license. However, I got confused on what to pick. We have one machine with a single processor. Does anyone have any idea on what to get? This is apparently my first time and there are a vast number of different options.
thanks in advance

http://www.jetansolutions.com

 

[SQLDenis]

if it is a webserver then you need per processer
if it is for internal use you can get a bunch (25 maybe) cals

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[mrdenny]

Take a look at this FAQ faq962-5153.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[FALCONSEYE]

thanks, i am building a clustered webserver with two seperate boxes.

http://www.jetansolutions.com

 

[FALCONSEYE]

Sorry for the double post. So, the things changed since the first post. Thanks for the link Mr.Denny.

http://www.jetansolutions.com

 

[FALCONSEYE]

Now that I read the information on the link Mr.Denny provided., I got two more questions.
When it comes to a clustered server, what is an active node and what is a passive node? Also, if I want to pick a SQL Server to install on a clustered environment, do I have to get the enterprise edition? Can't you install standard edition on two separate boxes with two different processor licenses? Thanks

http://www.jetansolutions.com

 

[mrdenny]

Active nodes are nodes which are currently running the SQL Service. Passive nodes are nodes which have SQL Server install but the service is not currently running on them.

If you are running a cluster with a single instance you will be running an active/passive cluster. If you have two instances you can be running either an active/passive cluster or an active/active cluster.

If you will be clustering SQL 2000 using the Microsoft cluster server you must be Enterprise Edition. Standard edition is not supported for a clustered installation.

Can't you install standard edition on two separate boxes with two different processor licenses?

That would not be a clustered SQL Server installation. That would be two independant SQL Servers.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[FALCONSEYE]

http://www.sqlservercentral.com/articles/Administration/2988/

tells me that SQL 2005 standard edition does support clustering. is this wrong?

http://www.jetansolutions.com

 

[mrdenny]

SQL 2005 Standard does support clustering. SQL 2000 Standard does not. You had specified SQL 2000.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[FALCONSEYE]

ok sweet. thanks

http://www.jetansolutions.com