SQL Server Versions supported with SharePoint 2016

In this article, I will answer the below SharePoint and SQL Server Compatibility

Which versions of SQL Server is supported with SharePoint 2016?

SQL Server Versions supported with SharePoint 2016


First, It’s 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.

Actually, that made me puzzled to maintain

  • The compatibility of SQL Server 2014 SP2 with SharePoint 2016.
  • The compatibility of SQL Server 2016 SP1 with SharePoint 2016.

So let’s answer the below questions to make it clear!


How to maintain SQL Server and SharePoint Compatibility?

SharePoint hintIn order to maintain SharePoint and SQL Server compatibility. Microsoft uses 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.

Is SQL Server Express supported with SharePoint 2016?

No, SQL Server Express is not supported with SharePoint 2016.

Is SQL Server 2012 supported with SharePoint 2016?

No, SQL Server 2012 is not supported with SharePoint 2016. 

Is SQL Server 2014 supported with SharePoint 2016?

No, SQL Server 2014 is not supported with SharePoint 2016. 

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

Is SQL Server 2014 SP2 supported with SharePoint 2016?

Yes, SQL Server 2014 SP2 is fully supported with 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.

hint-iconThe SQL Server Reporting Service 2014 SP1, SP2…etc is not supported with the SharePoint 2016.

You must have SQL Server 2016 to can configure SQL Server Reporting Service Integrated Mode on SharePoint 2016.

Is SQL Server 2016 SP1 supported with SharePoint 2016?

Yes, SQL Server 2016 SP1 is fully supported with SharePoint 2016.

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

SQL Server Compatibility for SharePoint 2016

hint-icon

  • The SQL Server 2017 is now supported with SharePoint 2016.
  • The SQL Server 2017 on Linux is not supported with SharePoint 2016.

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.


Applies To
  • SharePoint 2016.
  • SQL Server.
See Also
Advertisements

2 thoughts on “SQL Server Versions supported with SharePoint 2016

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s