SQL demo license expires

• SurfZ

  SSC Enthusiast

  Points: 107

  More actions

  April 13, 2005 at 5:05 am

  #164077

  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

• David.Poole

  SSC Guru

  Points: 75656

  More actions

  April 14, 2005 at 2:40 pm

  #552819

  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.

  LinkedIn Profile