Is SQL Server 2016 SP1 supported for SharePoint 2016?

It’s heavily recommended to check the Hardware and software requirements for SharePoint Server 2016 before you are going to Install SharePoint 2016,

In Hardware and software requirements for SharePoint Server 2016 article, specifically in Database Server requirements section, you will note that the database server requirements is one of the following:

  • The 64-bit edition of Microsoft SQL Server 2014 Service Pack 1 (SP1)
  • Microsoft SQL Server 2016 RTM.

sql-server-2016-with-sharepoint-2016

Actually, that made me puzzled to maintain the compatibility of SQL Server 2014 SP2 or SQL Server 2016 SP1 with SharePoint 2016! until
I found out the below equation in Technet:

hint-iconIn order to maintain SharePoint and SQL Server compatibility. Microsoft use the ‘SharePoint N-1 on SQL Server N+1‘ equation to determine version support.

  • For SharePoint Server 2016 as an example, the N release of SQL Server is 2014 SP1 and N+1 is SQL Server 2016.
  • For SharePoint Server 2013 the N release of SQL Server is 2012 and the N+1 is SQL Server 2014.
  • SharePoint Server 2010 as an example, the N release of SQL Server is 2008/2008 R2 and N+1 is SQL Server 2012.

Based on the above equation you would be able to answer the below questions without any type of confusion:

  • Is SQL Server Express supported for SharePoint 2016?
    • No, SQL Server Express is not supported for SharePoint 2016.
  • Is SQL Server 2012 supported for SharePoint 2016?
    • No, SQL Server 2012 is not supported for SharePoint 2016. 
  • Is SQL Server 2014 supported for SharePoint 2016?
    • No, SQL Server 2014 is not supported for SharePoint 2016. 

noteThe 64-bit edition of Microsoft SQL Server 2014 Service Pack 1 (SP1) that is supported for SharePoint 2016.

  • Is SQL Server 2014 SP2 supported for SharePoint 2016?
    • Yes, SQL Server 2014 SP2 is fully supported for SharePoint 2016.

noteThe service pack does not count towards the N equation.the SQL versions are SQL 2008, 2014, 2016, but not the updates or service packs.

  • Is SQL Server 2016 SP1 supported for SharePoint 2016?
    • Yes, SQL Server 2016 SP1 is fully supported for SharePoint 2016.

noteWhat is mentioned in  Hardware and software requirements for SharePoint Server 2016 is the minimum requirements for Database Server.

It’s also useful to answer the below related questions:

  • Which SQL Server Edition (Standard Or Enterprise) should be used for SharePoint 2016?
    • Based on your farm topology, It’s recommended to use SQL Server 2016 Enterprise Edition that comes with all features. especially if you are going to configure Always on availability group that will not be supported with the SQL Server 2016 Standard Edition. but if you are going to configure Always-on failover cluster you can use Standard edition.

hint-icon“Always On failover cluster”  in SQL Server 2016 Standard Edition is supporting  2 nodes. For more details check Editions and Supported Features for SQL Server 2016.

  • What’s the pricing for each SQL Server 2016 edition?
SQL Server 2016 editions Licensing model Open no level price (US$)
Enterprise Per core** $14,256***
Standard Per core** $3,717***
 Server + CAL**** $931***

For more details check SQL Server 2016 pricing

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s