MikeS wrote:SQL Server by default will use all available memory. You must setup the SQL server properties and allocate how much total memory for it to use.
The 100% memory allocation problem isn't occurring when the server is actually running, it only seems to happen when you're in the process of installing applications. Once everything is installed it ticks along quite merrily.
Web Edition is a very cut down version of the Windows Server software, it only allows you to have 2Gb of RAM max, you can't join it to a domain and you can't run SQL Server on it. The SQL Desktop Engines run okay but not the full editions.
Also, you can't upgrade from Web Edition to one of the other, fully featured version of Server as there's no supported upgrade path. Even trying to do it with a 'repair' install using a Server Standard Edition cd failed to upgrade a test version of Server 2003 is was playing with a while back.