May 20, 2005 at 5:30 am
Not being very experienced with SQL I must ask what is probably an easy question.
We would like to deploy a system that will have internet access. I need 20+ users to have access to a web server from the internet, not internally, which in turn will be connected to a SQL server. I want to use SQL 2000 standard edition on SQL server but have been told that it needs to run SQL 2000 enterprise. Is this true and if so why? Thanks for any responses.
May 20, 2005 at 6:30 am
There is no reason to use Enterprise Edition for these licensing prerequisites you give. Enterpise Edition contains features that Standard does not, but if you do not need those then you are ok with Standard Edition.
May 20, 2005 at 9:51 am
To expand on what Chris said... If your users are accessing the data through the internet you probably need to use the "Per Processor" license, this has nothing to do with the edition. Either Standard or Enterprise edition can be licensed in per processor mode.
Some of the major reasons that you might want to use Enterprise edition are: Clustering, more than 4 CPU's, more than 2GB of RAM.
There are certainly other features that are available in Enterprise Edition, but those tend to be the major decision points. For a more complete list of differences see Books Online articles "Editions of SQL Server" and "Maximum Capacity Specifications"
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
May 20, 2005 at 9:53 am
Thanks to you both for your replies.
Mark
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply