SQL Server 2014 and SharePoint supportability


SQL Server 2014 just hit RTM. I’m sure all the tech junkies out there are wondering when SharePoint will support SQL 2014. According to Bill’s post, it looks like official support for SQL 2014 and SharePoint 2013 will be included in the April 2014 CU for SharePoint 2013.

I’m sure some of you are going to ask about SharePoint 2010. I haven’t seen anything official, but I’ll venture a guess that we’ll never officially support SharePoint 2010 and SQL 2014.

http://blogs.technet.com/b/wbaer/archive/2014/03/21/sql-server-2014-and-sharepoint-server-2013.aspx

 

UPDATE 8/5/2015:
SP2010 is not supported on SQL 2014. There are no plans to support it in the future.

This link talks about how you can use PowerPivot/SQL 2014/Analysis Services and SP2010 together. That combo is supported, but only that combination. You cannot host SP2010 databases on SQL 2014.
https://msdn.microsoft.com/en-us/library/dn169381.aspx#SSAS

Comments (6)

  1. SR says:

    So has anyone on SharePoint 2010 upgraded their database server to SQL Server 2014?   Curious to know what the outcome is.  

    In the SQL Server 2014 release notes, Section 6.1, it states:

    "MSOLAP.5 must be downloaded, installed and registered for a SharePoint 2010 new farm configured with SQL Server 2014"

    msdn.microsoft.com/…/dn169381.aspx

    I'm guessing it works and Microsoft may provide some type of support behind it?  

  2. DVP says:

    This is a nonsense program. It only adds to the confusion instead of helping the matter. The resume never wroekd for me so far.

  3. vamsee krishna says:

    Hi i have a requirement like
    The existing environment is sharepoint server 2010 connected to sql server 2008 R2 and the requirement is sharepoint server 2010 with sql server 2014
    Is it compatible for 2014 as lot of resources on the web are confusing.
    Sharepoint Server 2010 with SQL server 2014

    1. Ron Grzywacz says:

      SQL 2014 will never be supported for SharePoint Server 2010. SQL and SharePoint support generally works in the follow way. A SharePoint release will support the latest SQL Server Version(n) as well as the previous supported versions (n-2) and one addition/new release of SQL (n+1). Make sense?

      1. BS says:

        So what is the current status,

        what is the current status, is SQL 2014 SP2 is compatible with SharePoint 2013?

    2. BS says:

      what is the current status, is SQl 2012 SP2 is compatible with SharePoint 2013?