Recently had a discussion with a colleague as someone tabled migrating our SharePoint 2010 databases to the a newly created SQL Server 2014 cluster. I was like im pretty sure SharePoint 2010 is not supported with SQL Server 2014. After some googling and looking at a million websites, found the answer (its not), and was like why isn’t there a compatibility matrix for SharePoint. Hence this post.
| SharePoint 2010 | SharePoint 2013 | SharePoint 2016 | SharePoint 2019 | |
| SQL Server 2005 | X(min SP3) | |||
| SQL Server 2008 | X(min SP1) | |||
| SQL Server 2008 R2 | X | X | ||
| SQL Server 2012 | X | X | ||
| SQL Server 2012 R2 | X | |||
| SQL Server 2014 | X | X(min SP1) | ||
| SQL Server 2016 | X | X | ||
| SQL Server 2017 | X | X |
NP – 64bit versions of SQL Server only.
NPP – SharePoint On-Prem only.
Last Updated – 18th May 2019.
1 Giant Nerd 