SharePoint 2013/2016 and SQL Server 2016 Supportability with SSRS fun facts!


UPDATE: Corrections/clarifications were made on 7/12/2016. Thanks for the comments! 🙂


It's come up in the last few days where people want to know if SharePoint 2013 will support SQL Server 2016. (support as in store all SP's DB in...) The answer to this question is no, SharePoint 2013 will never be supported on SQL 2016. (with the exception of SSRS integration, keep reading for that) SQL and SharePoint support generally works in the following way. A SharePoint release will support the latest SQL Server version(n) at the time of release as well as the one previous released version (n-1) and one addition/new release of SQL (n+1). For the case of SharePoint 2013, the follow SQL versions are supported:

SQL 2014 - n+1
SQL 2012 - n
SQL 2008 R2 - n-1

If we want to expand this list to SP 2016, we can assume we'll support the following

SQL 201#/TBD - n+1
SQL 2016 - n
SQL 2014 w/SP1 - n-1

 

SQL Server Reporting Services Integration rules
The part of this discussion that gets a little confusing is SQL Server Reporting Service (SSRS) integration. Since SP is just using the SSRS add-in to render reports, the supportability matrix does expand some. In the table in the link below, we can see that you can integrate SSRS 2016 with SP2013 via the SSRS2016 add in.

Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2016) - https://msdn.microsoft.com/en-us/library/gg492257.aspx
Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2014) - https://msdn.microsoft.com/en-us/library/gg492257(v=sql.120).aspx
Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2012) - https://msdn.microsoft.com/en-us/library/gg492257(v=sql.110).aspx

 

SSRS 2016 - SP2016, SP2013, SP2010, SP2007
SSRS 2014 - SP2013, SP2010, SP2007
SSRS 2012 - SP2013, SP2010, SP2007

 

SQL 2016 Always Encrypt

I had a few questions recently about SharePoint 2016 supporting SQL 2016's Always Encrypted feature. We currently do not support this feature. If you're interested in getting it tested/supported, PLEASE PLEASE PLEASE, submit feedback on https://sharepoint.uservoice.com/. PLEASE! 🙂

Comments (7)

  1. BS says:

    Does SQL 2014 SP2 is compatible with SharePoint 2013?? My client is asking upgrade the SQL to 2014 SP2. Is there any MS article to support this (if it is compatible)?

    1. Ron Grzywacz says:

      SQL 2014 is supported across all service packs, assuming the proper SharePoint 2013 CU.
      https://blogs.technet.microsoft.com/wbaer/2014/03/21/sql-server-2014-and-sharepoint-server-2013/

  2. cheap madden 17 coins says:

    Many thanks extremely beneficial. Will certainly share website with my friends

  3. We are looking to upgrade SQL Server 2012 to SQL 2016 for sharepoint 2013,dose this supportable

  4. Elliot H says:

    Does this mean that SP is not capable of running in SQL 2016 but with the databases running in compatibility mode of SQL 2014?

    1. Ron Grzywacz says:

      Correct. SharePoint is tested against SQL releases, not database compatibility modes. While it could work, it’s not a supported configuration.

Skip to main content