1

Can we use SharePoint 2010 with SQL server 2014? At our organization we have our SharePoint farm which is currently on SharePoint 2010 with SQL server 2008 R2. We are undergoing an SQL server upgrades for all our database servers (We have technologies being used other than SharePoint) and we don't want to tie SQL upgrade process to SharePoint upgrade.

So my Question is if we can use SQL 2014 with SharePoint 2010 in any form by either running SQL server in compatibility mode or by installing any patches for SharePoint. If we can use it what are the chances that it might break something in SharePoint and how can I verify this before doing it in production environment (We have live content management website in SharePoint)? It would be great if someone who has used this combination could comment.

3

SharePoint 2010 is not supported on Microsoft SQL Server 2014. Version support is determined by the equation in the following:

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 Foundation 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.

What that means SharePoint 2010 is not supported on SQL 2014. There are no plans to support it in the future.

SQL Server 2014 and SharePoint supportability

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

  • It is not supported but what if we run SQL server 2014 in compatibility mode, it can work that way (of course still not supported by MS) so my question is if someone has ever used this combination? – KayEye Feb 16 '16 at 15:45
  • I dont think it is good idea as this your production. I am ok with Dev farm...It may work but once it broke then you will be out of luck as your DBs upgraded to sql 2014 and cant go back and MSFT will not rescue you. – Waqas Sarwar MVP Feb 16 '16 at 15:50
  • yeah you may be right we should not go for anything in production environment which is not recommended by Microsoft. – KayEye Feb 16 '16 at 15:54
0

Unsupported, but it works except for UPS sync.

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

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.