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.

I'm planning to run a ms sql server 2008r2 express edition on a windows server 2008R2 foundation edition. Is it possible? what are the possible issues?

share|improve this question
add comment

1 Answer

You can install SQL Server on 2008 R2 Foundation but you have to consider some drawbacks due to Foundation edition limitations. Please note that Foundation is limited to one CPU socket support, 8 GB ram maximum and you have a limit on network connections. Nowadays a single socket will support many CPU cores, so processing power may not be a problem, but the limited number of connections and the small amount of ram supported can be. It depends on how much work your databases will do and how they will be optimized. Because of Foundation is a so limited edition, I would not recommend to install SQL server on it for other that very small and low profile databases.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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