Is it possible to build a "free" server (SQL Server Express + Sharepoint Foundation) when the number of concurrent users will be about 20 with the total number of about 100. Both SQL Server and Sharepoint will be running on the same Windows Server 2008 (not sure which edition yet). Will this work? Or I need to consider paid versions?

  • what deployment will you install? The maximum amount of data you can store in this environment is 4GB.
    – Thuan
    Aug 4, 2011 at 2:43
  • 1
    I think they bumped SQL Express up to 10gb and you can multiply that ad much as 10x if you implement RBS.
    – Rob D'Oria
    Aug 4, 2011 at 3:02

2 Answers 2


Users will definitely not be an issie so you probably only need to be concerned with content volume. With SharePoint Foundation and SQL 2008 Express you have a 10GB limit but can implement RBS FILESTREAM OR 3rd party RBS provider to increase the amount of content you can manage in the environment...probably upwards of 75-100GB.


This should work. As Rob says, it is only going to be a problem if you put in huge amounts of content (unlikely given the number of users).

However, I wouldn't recommend using RBS (FILESTREAM) to get around the storage limit on SQL Express, other than to get around a particular 2007 upgrade scenario. I just don't think it is worth the trouble and complexity compared to the cost of a SQL Server licence, in my opinion. Can't see it being an issue though with that number of users - you have 10 Gb to play with.

  • You will definitley want to monitor your resources closely. 100 concurrent users browsing not much of an issue, 100 users uploading/download docs at the same time you may start to see issues with SQL keeping up. SQL Express is limited to utilizing only 1 CPU (core), and 1GB RAM. Aug 4, 2011 at 13:36
  • He anticipates 20 concurrent users, but a valid point nonetheless.
    – SPDoctor
    Aug 4, 2011 at 18:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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