SharePoint 2013 on SQL 2016 in SQL 2014 compatibility mode supported or not?

Question

_{Tuesday, October 3, 2017 11:59 AM}

Hi,

i have a customer who would like to install sharepoint 2013 on a SQL server 2016 installation running in SQL 2014 mode. Is this a supported scenario?

best regards

Marc

All replies (4)

_{Tuesday, October 3, 2017 12:51 PM ✅Answered | 2 votes}

SharePoint 2013 does not support SQL 2016. You need to use SQL 2014 at the maximum. As Responded here

Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -Waqas Sarwar(MVP) Blog: http://krossfarm.com

_{Wednesday, October 4, 2017 8:15 AM ✅Answered | 2 votes}

Hi MarcPlet, 

SharePoint 2013 supports several versions of SQL Server: SQL Server 2008 R2 with Service Pack 1 (SP1) or SQL Server 2012, or SQL Server 2014 64-bit versions. 

Refer to the following article about Overview of SQL Server in a SharePoint environment (SharePoint 2013)

https://technet.microsoft.com/en-us/library/ff945791.aspx

Besides, SQL Server 2014 requires the May 2014 Cumulative Update to be installed. To install the May 2014 Cumulative Update see Updates to SharePoint 2013. 

Reference:

https://technet.microsoft.com/library/a88d3f72-7ac3-4f08-b302-c4ca0a796268(v=office.16).aspx
Best Regards, 

Lisa Chen 

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected]

_{Tuesday, October 3, 2017 1:47 PM}

Hi MarcPlet,

To add to Waqas, you have to use SP2013 with SP1 to use SQL 2014.

Regards,

SAGAR PATIL

_{Friday, October 13, 2017 2:06 AM}

Hi MarcPlet, 

Is there anything update?

Please remember to mark the helpful posts as answers.

Have a nice day!

Best Regards,

Lisa Chen

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected]