I'm in the process of looking for a dedicated server to host my soon to be released web apps. THey are build with ASP.NEt and uses Sql Server 2005. I've got a great deal with a company for a Intel Core2Quad Q9300 with 8Gb or ram and 750Gb sata.
They offer me Windows 2003 64 Standard or Windows 2008 64 Web for free, which one should I choose?
My main concern is about the database, in the first moment I'm going to have only one box to host both the web and database layer. Will I be able to install SQL Server (initially the express edition, then eventually the standard) on the Web version of Windows 2008?
Best Answer
If you can get Server 2008, i'd go with it because IIS7 is an excellent Upgrade to IIS6.
SQL Server Standard 2008 64-Bit is officially supported on Windows 2008 Web Server. SQL Server Enterprise 2008 64-Bit is NOT (not sure if it does work and is only not listed. 32-Bit Enterprise is listed, but running 32-Bit on a modern server does not sound appealing). See System Requirements here for a full list of SQL Server 2008 Editions and supported Servers.
Not sure about SQL Server 2005, there seems to be a patch needed.