SharePoint 2013 and SQL Server 2016


A common question we receive is whether SharePoint 2013 is supported with SQL Server 2016.

The answer here is clear: SharePoint 2013 is NOT supported with SQL Server 2016.

Only the following SQL Server versions are supported with SharePoint 2013:

  • The 64-bit edition of SQL Server 2008 R2 Service Pack 1
  • The 64-bit edition of SQL Server 2012
  • The 64-bit edition of SQL Server 2014

There are currently no plans to add support for SQL Server 2016.

See here for more details on this topic:

Comments (28)

  1. Andy says:

    Hi Stefan,

    Great article.
    How about SharePoint 2016 on SQL Server 2016?

    Thanks,
    Andy

    1. Hi Andy,
      SharePoint 2016 is supported with Microsoft SQL Server 2016 RTM (and also with 64 Bit Edition of Microsoft SQL Server 2014 Service Pack 1).
      See here for Details:
      https://technet.microsoft.com/en-us/library/cc262485(v=office.16).aspx#section4
      Cheers,
      Stefan

  2. Andy says:

    Thanks a lot Stefan,
    May I bother you with one more question?
    Is SQL Server 2008 R2 CU3 supported with SharePoint 2010 SP1 ?

    Thanks a lot for your help.

    Andy

    1. Hi Andy,
      that should be supported.
      Cheers,
      Stefan

  3. Carol says:

    Does SP2016 support content deployment? Thank you.

  4. Elton Oliveira says:

    Stefan,

    Would it be a problem to deploy the SharePoint Server 2013 on SQL Server 2016 by using the compatibility level with SQL Server 2014 SQL Server feature (Production/Development environments)? Taking advantage of this for the natural subsequent question: what about SPS2010 on MSSQLSERVER2014 with MSSQLSERVER2012 compatibility level?

    1. Hi Elton,
      sorry – that is unsupported.
      It is the product version that counts – not the compatibility level.
      Cheers,
      Stefan

  5. Chris says:

    Stefan,
    Thanks for the great information. Another compatibility question: is SharePoint 2013 supported on Windows Server 2016. I have not seen any official statement to the effect that it is either supported or not supported. Thanks. Chris

    1. Hi Chris,

      the supported OS versions are stated here:
      https://technet.microsoft.com/en-us/library/cc262485.aspx

      “We only support the 64-bit edition of Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, or Datacenter or the 64-bit edition of Windows Server 2012 Standard or Datacenter.”

      The last info I got on this topic is that there are currently no plans to support SharePoint 2013 on Windows Server 2016.

      Cheers,
      Stefan

      1. Just being a nitpicker – how about Windows Server 2012 R2? That isn’t officially supported for SharePoint 2013?

        1. Hi Henning,
          indeed SharePoint 2013 RTM does not support it. Support for Windows Server 2012 R2 has been added SharePoint 2013 with SP1 (the slipstream builds available on VLSC and MSDN):
          https://support.microsoft.com/en-us/kb/2891274
          Cheers,
          Stefan

          1. I see – I would have expected to see this information in the TechNet article you mentioned above as well, as this would be my first-stop-shop for such informations

          2. Indeed. It seems to be an oversight that this article has not been updated.
            I will open a change request for the article to ensure that it includes this information.

  6. Bryan says:

    Is SharePoint 2016 compatible with SQL 2016?

  7. shivraj says:

    sharepoint 2013 is supported to win server 2016

  8. Isabel says:

    Hi Stefan,

    For the SQL Server 2016, we found that there was a new build SP1 (https://www.microsoft.com/ja-JP/download/details.aspx?id=54276), we are confusing that if this new SQL Server 2016 SP1 can support SharePoint 2013
    Thanks in advance!

    1. SharePoint 2013 only supports the SQL versions listed in my post above. SQL Server 2016 (independent from the service pack level) is not supported.

      1. Wurstsalat says:

        Dont like what i read 🙂

        while Dynamics ax 2013 R3 Added Support for SQL 2016, it still stucks at SharePoint 2013 Support (and wont be added in future)…but SharePoint 2013 is stuck on SQL 2014 :/
        Would great to participate in a whole of the new Features of SQL 2016 and dont have to choose between the versions

        1. SharePoint 2016 supports Windows Server 2016 and SQL Server 2016.
          So upgrading to the most current version of SharePoint would fulfill your wishes.

  9. BigPhil says:

    You state that SharePoint 2013 is not supported on SQL Server 2016, but I cannot see any reasons why. Is it just that it has not been thoroughly tested on 2016, or are there aspects of 2016 functionality which break SharePoint 2013?

    1. Hi Phil,
      SharePoint 2013 has not been tested on SQL Server 2016 so we don’t have any info what works and what will break.
      Therefore using SharePoint 2013 on SQL Server 2016 is unsupported.
      Cheers,
      Stefan

  10. Mike K says:

    This is out of date. I see plenty of pages saying it is supported by Microsoft and they are Microsoft pages.

    1. Please show me one.
      Thanks.

        1. SharePoint 2013 can work with SQL Reporting Services from SQL 2016. But SharePoint 2013 databases are unsupported on SQL 2016.

Skip to main content