Using SQL Server 2012 with SharePoint 2010

Configure and manage SQL Server availability groups for SharePoint ServerThere has been a lot of interest in using SQL Server 2012 with SharePoint 2010.  Below are some official Microsoft documents that outline general requirements and feature support.

In a previous post I mentioned that service pack 1 for SharePoint 2010 is required in order to install SharePoint 2010 with SQL 2012.  Specifically you need service pack 1 if you are going to use the SQL Server 2012 engine for the SharePoint content databases or catalog databases.   The service pack is also required if you want to use PowerPivot or the PowerPivot configuration tool.

The knowledgebase article 2460045 describes what is included in SharePoint Server 2010 Service Pack 1.  One specific bullet point under improvements states “Support for Microsoft SQL Server 2012.”

Update 04/24/2012:  I ran across this great video showing a demonstration of SQL 2012 AlwaysOn capability with SharePoint 2010.  A new TechNet article has also been published on how to Configure and manage SQL Server availability groups for SharePoint Server.

 

Reference documentation:

Guidance for Using SQL Server BI Features in a SharePoint Farm

Supported Combinations of SharePoint and Reporting Services Components

Installing Reporting Services SharePoint Mode Report Server for Power View and Data Alerting

PowerPivot for SharePoint Installation

SQL Server 2012 Product Documentation

Configure and manage SQL Server availability groups for SharePoint Server

Microsoft Virtual Academy: Deploying and managing PowerPivot in Microsoft SQL Server 2012 for SharePoint 2010

Microsoft Virtual Academy:  Installing and Configuring Reporting Services in SharePoint Integrated mode Part 1

Microsoft Virtual Academy: Installing and Configuring Reporting Services in SharePoint Integrated mode Part 2

4 thoughts on “Using SQL Server 2012 with SharePoint 2010”

    1. Check out the following blog post which outlines a new PowerShell command to enable Access Data Connection: http://blogs.msdn.com/b/jtarquino/archive/2012/02/03/10229987.aspx

      You need to run a PowerShell command to enable the Access Data Connection. In the previous version of Reporting Services you would just modify the rsreportserver.config file.

      You do still need to modify the rssrvpolicy.config file like you did in the previous version of Reporting Services. Do note that the file has been moved to the ..14/WebServices/Reporting directory on your SharePoint server that is running the Reporting Services SharePoint service. The changes you need to make to the rssrvpolicy.config file can be found towards the bottom of the page here: http://technet.microsoft.com/en-us/library/ee662542.aspx

      I have configured my demo environment this way and have been able to use SQL 2012 Reporting Services with SharePoint 2010 Access Services.

  1. Hi I am trying to setup a SQL Always-On cluster for use with SharePoint 2012. I have posted here http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/b85b990a-f4da-4480-8f38-49dd0003012c and so far the cluster is up and I now and ready to install SharePoint 2012 to the availability group access name.

    I understand how the MSSQL engine will cluster data, but what about reporting services and analysis services? Do these need to be clustered, or does SharePoint reference these servers as seperate instances?

    Any points on the above, or SharePoint with SQL 2012 Always-On would be much appreciated.

    Thanks, Chris

  2. Hello all,I would like to ask that what are the benefits of sql training, what all topics should be covered and it is kinda bothering me … and has anyone studies from this course wiziq.com/course/125-comprehensive-introduction-to-sql of SQL tutorial online?? or tell me any other guidance…
    would really appreciate help… and Also i would like to thank for all the information you are providing on sql.

Leave a Reply