In official requirements the supported versions of SQL Server are 2014 SP1 and 2016. It is not clear are 2014 SP2 and 2016 SP1 supported?

I need to set up devtest 3-tier farm for SharePoint 2016. I already have one dedicated machine with SQL Server 2014, which way should I go - update it to SP1 or SP2 or reinstall 2016 or 2016 SP1?

Also I need to set up single server dev env for SharePoint 2016. I have already installed SQL Server 2014 SP2, but not started with SP2016. Should I continue with SP or reinstall SQL Server 2014 SP1?

2 Answers 2


Yes it is supported, as Article mentioned the minimum requirement and N-1 equitation between the SQL version not the updates.

In order to maintain SharePoint and SQL Server compatibility we use the “SharePoint N-1 on SQL Server N+1” equation to determine version support. Using SharePoint Server 2010 as an example, the N release of SQL Server is 2008/2008 R2 and N+1 is SQL Server 2012. For Microsoft SharePoint Server 2013 the N release of SQL Server is 2012 and the N+1 is SQL Server 2014.


Yes you can go ahead and upgrade the SQL with Sp2 and complete you installation.

  • Hi @Waqas based on your clarification should you tell me what this mean with SQL 2014 w/SP1 – n-1 ?? if we consider this a version so it means SharePoint 2016 can be installed on SQL 2012 with SP1 Right ? is this what do you mean ? if right I think Microsoft mention it's not installed on SQL Server 2012 , meanwhile are you consider this link blogs.msdn.microsoft.com/ronalg/2016/06/13/… official link , Commented Nov 30, 2016 at 15:54
  • No...N mean release of SQL version, so for SharePoint 16...N-1= 2016-1= 2014 and N+1 = will future version.....they link you are referring is SSRS.... read from here technet.microsoft.com/en-us/library/…
    – Waqas Sarwar MVP
    Commented Nov 30, 2016 at 16:05
  • Thanks Waqas for your reply , based on your link we agree on (N) is a version ? and based on my link you said it's for SSRS , so if I need to install SharePoint 2016 with SSRS I can't install it with SQL 2014 w/SP2 , Right ? because he mentioned only (SQL 2014 w/SP1 – n-1) so if we apply N as version that mean I can install SP 2016 with SQL 2012 SP1 !! but this version of SQL is not supported with SharePoint 2016 !!!! so whatever it's for SSRS or not , but in fact I can't install SharePoint 2016 with SQL Server 2012 SP1 ! Commented Nov 30, 2016 at 16:18
  • Service pack not count towards the N equation....Version are SQL 2008, 2014, 2016, but not the updates/ service pack...if there is any requirement then MSFT tell that if a version with SP is required
    – Waqas Sarwar MVP
    Commented Nov 30, 2016 at 16:39
  • 1
    No for sharepoint 2016, n is sql 2016 and n-1 will be 2014 not 2012
    – Waqas Sarwar MVP
    Commented Nov 30, 2016 at 16:40

Does SharePoint 2016 support SQL Server 2014 SP2?

As a short answer Yes, you can install SharePoint 2016 with

  • SQL Server 2014 SP2.
  • SQL Server 2016 SP1.

For more details, please check Supported SQL Server Version for SharePoint 2016

In Microsoft Docs, SharePoint 2016 supports

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

Actually, this is the Minimum baseline requirements for a database server on a farm. so any current and future SPs should be supported.

Check also

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.