April 13, 2005 at 5:05 am
Hello, I installed the demo verion of SQL server 2000 on our webserver. We are happy with the product, which version should we buy? There is 1 webmaster who is the only 1 that edits the database and of coarse a lot of regular internet users who browse internet pages with links to records in the database. So that makes 2 users.
So:
1. Which version, we prefer the cheapest version
2. Where can I add the license number to register the demo version that we currently are running?
Thanks
April 14, 2005 at 2:40 pm
MSDE is a cut down version of SQL Server without any front end tools. Maximum database size is 2GB and max ram is 2GB.
If you are talking about small, low traffic web sites then you may get away with this.
SQL Server Standard edition gives you the front end tools and the database size isn't limited. Max RAM is 2GB.
Enterprise edition is way over the top for one box web sites. RAM is dependent on the version of Windows.
I don't like running SQL on a web server, personally I like a sacrosanct database server behind a firewall and front end web server(s).
Licensing for web apps is per processor.
I would uninstall your demo version and do a clean install of SQL server to avoid any possible registry problems.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply