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.

I installed the 64 bit version of Server 2008 Enterprise and I am having issues with other computers on the network being able to access drives on the server. I setup a 750 GB drive to share, changed the permissions to all users, allowing anything on the drive to be accessed and changed etc.
When I try to access the drive or a folder on the drive it says "Windows cannot access" the drive/folder or whatever.

When I had the 32 bit version installed I did not have these problems.