1

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?

1

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.

https://technet.microsoft.com/en-us/library/cc262485(v=office.14).aspx#section4

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 , – Mohamed El-Qassas MVP Nov 30 '16 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 Nov 30 '16 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 ! – Mohamed El-Qassas MVP Nov 30 '16 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 Nov 30 '16 at 16:39
  • 1
    No for sharepoint 2016, n is sql 2016 and n-1 will be 2014 not 2012 – Waqas Sarwar MVP Nov 30 '16 at 16:40
1

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.

In Hardware and software requirements for SharePoint Server 2016, it's mentioned the SharePoint 2016 is supported with

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

I already confused but I have tried this scenario on my side that working properly.

So what was mentioned in MSDN Article is considered the Minimum requirements for a database server in a farm and you can go ahead to install SharePoint 2016 with [SQL Server 2014 SP2] or [SQL Server 2016 SP1] as you like.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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