Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
Can you help me with my software licensing question?

What is Minimum Windows Server licence to run a SQL server for use in a web farm. Can I run a SQL on a Server2008 Web edition?

share|improve this question
add comment

marked as duplicate by Iain Feb 2 '12 at 21:34

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

2 Answers

up vote 3 down vote accepted

The MSDN website has a detailed description of all the Operating System requirements for the various editions of SQL Server 2008 from the Express right through the Data Center editions. The requirements for the OS change as you move through the versions. Express will run on consumer operating systems, but it appears that most of the versions of Windows Server have a corresponding edition of SQL Server 2008.

http://msdn.microsoft.com/en-us/library/ms143506.aspx

share|improve this answer
add comment

It depends on the SQL Server version and license type, from "Standard" to "Enterprise."

The latest version, SQL Server 2008, runs as "Standard" even on Windows XP Service Pack 2. The minimum Windows Server version is Windows Server 2003 (with SP2).

SQL Server 2008 Enterprise requires a Server operating system, Windows Server 2003 or 2008.

Windows Server 2008 Web allows you to install all versions of SQL Server 2008, while you can only install SQL Server Express on the Windows Server 2003 Web Edition (SP2). It has some limitations:

  • CPUs: Only 1 CPU. If a system has more than 1 SQL Server Express 2008 will still run but limit itself to one CPU
  • RAM: 1 GB. More RAM can exist, but SQL Server Express 2008 will use only 1 GB
  • Database Size: maximum 4 GB
share|improve this answer
    
"You can only install SQL Server Express on the Windows Server 2003/2008 Web Edition (SP2). " Not if you read the link from kdmurray SQL Server 2008 Standard (64-bit) x64 The following table shows system requirements for SQL Server 2008 Standard (64-bit) x64: Operating system: Windows Server 2008 x64 Web With the note: Management Tools are supported in WOW64, a feature of 64-bit editions of Microsoft Windows that enables 32-bit applications to execute natively in 32-bit mode. –  Gargamel May 27 '09 at 7:45
    
You are right, I wasn't aware that this changed in Windows Server 2008. I updated my answer. Thank you very much! –  splattne May 27 '09 at 7:56
    
NP, tanks for answering, we all learn new tings each day =) /Kalle –  Gargamel May 27 '09 at 14:44
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.