SharePoint SQL Server Support Matrix

Is SQL Server [Insert Version] supported with SharePoint?

Following up on my SharePoint Windows Matrix, here’s the same thing only with supported SQL Server versions.

20132010200720032001
SQL Server 2012All editions
64-bit
All editions
Requires SharePoint SP1
64-bit
SQL Server 2008 R2SQL Server SP1
All editions
64-bit
All editions
64-bit
All editions
Requires SharePoint SP2
32-bit, 64-bit
SQL Server 2008SQL Server SP1 + CU2 or CU5
CU3 or CU4 not recommended
All editions
64-bit
All editions
Requires SharePoint SP1
32-bit, 64-bit
SQL Server 2005SQL Server SP3
All editions
64-bit
SQL Server SP1
All editions
32-bit, 64-bit
SQL Server SP4
Standard 32-bit, 64-bit
Enterprise 32-bit, 64-bit
Workgroup 32-bit, 64-bit
SQL Server 2000SQL Server SP4
All editions
32-bit, 64-bit
Standard 32-bit, 64-bit
Enterprise 32-bit, 64-bit
Workgroup 32-bit, 64-bit
MSDE 32-bit, 64-bit
All editions
SQL Server 7.0All editions

Notes

  1. An empty cell mean this SQL Server/SharePoint combination is not supported.
  2. This table reflects all SharePoint editions, i.e. WSS/Foundation and Server Standard/Enterprise/Internet Sites. In other words within a SharePoint version, the SQL Server requirements are the same.
  3. I’ve indicated if a minimum SQL Server or SharePoint Service Pack is required otherwise assume RTM and later.
  4. The documentation isn’t always complete. When specific editions are not provided, I’ve assumed all mainstream editions (e.g. Standard, Enterprise, Datacenter, Web, Workgroup, Express) are supported and used the phrase All editions.
  5. Why have I listed unsupported versions of SharePoint? One day you’ll encounter one of these ancient farms in need of some help and the answer will be obvious.

References

Stories say it best.

Sorry, we couldn’t find anything that matches your search.

Are you ready to make your workplace awesome? We're keen to hear what you have in mind.

Interested in learning more about how we work?

Explore our culture and transformation and digital workplace services.